El Grupo Global de Desarrollo de PostgreSQL ha anunciado hoy el lanzamiento de PostgreSQL 13. La nueva versión cuenta con mejoras en el rendimiento y en la seguridad, así como con importantes características como la cláusula WITH TIES del estándar SQL (que se utiliza con LIMIT), la compactación de duplicados en índices B-tree, mejoras para bases de datos de gran tamaño, y más. Las numerosas...

The PostgreSQL Global Development Group today announced the release of PostgreSQL 13. The new release boasts improvements in performance and security as well as notable features such as the SQL-standard WITH TIES clause to use with LIMIT, B-tree deduplication, improvements for large databases, and more. The many features and enhancements in PostgreSQL 13 help improve the overall performance of...

Window functions in PostgreSQL are a very useful tool; and since their introduction 10 years ago, they have been gradually adopted for various use cases where a simple aggregation is just not flexible enough — case in point, incremental totals and moving averages. The features introduced in PostgreSQL complete the implementation according to the SQL:2011 standard, adding capabilities such as range...

Vacuuming is a key feature of PostgreSQL databases to keep databases healthy and optimized. When enabled, autovacuum conserves space by removing obsolete disk usage and optimizes database performance by speeding up sequential scans, among many other benefits. As part of the ongoing PostgreSQL Webinar Series, 2ndQuadrant hosted a webinar on Postgres Vacuuming Through Pictures , which covered key...

Among the many reasons to Migrate to PostgreSQL, dedicated support and seamless transition are key drivers for a business considering migration. Being open-source software, PostgreSQL provides a highly reliable, stable, scalable, and secure database migration, keeping in mind the unique needs of every business. Migration to PostgreSQL, however, can still be an extensive process as it requires...

Increasing robustness of Full Text Search in PostgreSQL allows applications like Search Engines and Text Editing Software to utilize native support without the need for 3rd party search tools. The release of PostgreSQL 12 added new capabilities to Full Text Search in terms of rich features, performance improvements, efficiency and more. 2ndQuadrant hosted a webinar to help understand what Full...

With applications evolving over time, there’s a need to enhance and evolve database schema as well. Sometimes this process involves some database tables and columns, creating new constraints and indexes, or even changing data types. In order to discuss Schema Migration in detail, 2ndQuadrant hosted the “ Application Schema Migration” webinar, providing an in-depth overview of database schema...

Securing data in motion is a necessity in today’s world. PostgreSQL provides a way to encrypt and authenticate communication by using a Secure Sockets Layer or SSL protocol. 2ndQuadrant hosted a webinar to give an introduction on using SSL, encryption and authentication methods, and how to successfully configure and deploy SSL with PostgreSQL. The webinar was presented by Andrew Dunstan...

High availability has become a requirement for any application these days. Achieving high availability in PostgreSQL is not just about replicating data across different nodes, but to do so in a way that optimizes the replication process. 2ndQuadrant hosted the “Achieving High Availability with PostgreSQL” webinar to explain High Availability concepts in PostgreSQL, best practices, how to configure...

The demand for PostgreSQL within the financial industry has been rapidly increasing in the recent years; mainly due to reduction in licensing costs, better choice of open source tools, and the robust enterprise features that PostgreSQL provides. 2ndQuadrant hosted the “Banking on Postgres” webinar to discuss attributes of financial databases based on Postgres, configuration processes, hardware...