2ndQuadrant’s Passion for PostgreSQL

2ndQuadrant was founded in 2001 by Simon Riggs, a major developer and committer of the PostgreSQL project. The vision was to create a business that bridges the database needs of enterprise users and open source contributions to PostgreSQL. Building on that vision, over the past 15+ years, 2ndQuadrant has widely contributed to the growth and development of PostgreSQL, earning us the prestigious title of Major Sponsors of the community. 

The 2ndQuadrant team has since grown to host the largest collective of PostgreSQL experts in a single organization. Our engineers and developers are globally recognized for their expertise in PostgreSQL products and services. We are well represented in the community and many of our experts are major contributors and committers to the PostgreSQL project. 

Below is a summary of our contributions to open source PostgreSQL over the past years. 

PostgreSQL 10 (released October 2017)

On October 2017, version 10 was released, presenting significant enhancements and introducing important new features to achieve faster data access, management and analysis. This major release also marks the change in the notation used to scheme versions to a two-digit format.

The features and enhancements contributed by 2ndQuadrant to PostgreSQL 10 are listed below:

A detailed list of  2ndQuadrant’s contributions to PostgreSQL 10 is available here.

*The features listed above have been taken from the Release Notes for PostgreSQL 10 from www.postgresql.org available here

PostgreSQL 9.6 (released September 2016)

PostgreSQL version 9.6 was released on September 2016, including a long awaited feature: parallel execution of large queries. David Rowley and Simon Riggs contributed to this effort alongside with many other developers to develop this robust feature. The team at 2ndQuadrant has continued to other several major improvements and new features in this release, listed below:

  • Improved performance of short-lived prepared transactions - Simon Riggs / Stas Kelvich / Pavan Deolasee 

  • Improved performance by moving buffer content locks into the buffer descriptors - Simon Riggs / Andres Freund  

  • Reducing the lock strength needed by ALTER TABLE when setting fillfactor and autovacuum-related relation options -  Simon Riggs / Fabrízio de Royes Mello

  • Ability to use an index-only scan with a partial index when the index's predicate involves column(s) not stored in the index - Tomas Vondra / Kyotaro Horiguchi 

  • Improved planner's estimate of the number of distinct values in a query result - Tomas Vondra 

  • Using foreign key relationships to infer selectivity for join predicates - Tomas Vondra / David Rowley 

  • Improved ANALYZE's estimates for columns with many nulls - Tomas Vondra / Alex Shulgin

  • Adding function pg_current_xlog_flush_location() to expose the current transaction log flush location, and adding log_line_prefix option %n to print the time as a Unix epoch, within milliseconds - Tomas Vondra / Jeff Davis 

  • Adding --with-systemd configure switch to enable calling sd_notify() at server start and stop - Peter Eisentraut 

  • Merging the archive and hot_standby values of the wal_level configuration parameter into a single value replica, adding syslog_sequence_numbers - Peter Eisentraut 

  • syslog_split_messages configuration parameters to provide more control over message format when logging to syslog - Peter Eisentraut 

  • Letting pg_basebackup use a replication slot defined for WAL streaming. After the base backup completes - Peter Eisentraut 

  • Selecting the same slot for regular streaming replication allows seamless startup of the new standby server - Peter Eisentraut 

  • Including the table name in object tags for object types that are only uniquely named per-table in pg_dump - Peter Eisentraut 

A complete list of  2ndQuadrant’s contributions to the PostgreSQL 9.6 is available here

*The features listed above have been taken from the Release Notes for PostgreSQL 9.6 from www.postgresql.org available here.

About 2ndQuadrant

2ndQuadrant is the team of diligent PostgreSQL experts. Our support engineers have over 100 years of combined code contributions to the PostgreSQL project, making us the only company to contribute enterprise features to all of the last 13 releases.

This is paired with 17+ years of hands-on experience through client engagements and allows us to integrate customized solutions with our customers - making 2ndQuadrant the Gold Standard for PostgreSQL products & services.


2ndQuadrant Updates

Tieniti in contatto con noi.

Iscriviti alla nostra newsletter trimestrale: riceverai le ultime notizie su 2ndQuadrant e aggiornamenti sulle tecnologie da noi supportate

La tua privacy è tutelata in base alla normativa vigente (art. 13 D. Lgs. 30.06.2003, n. 196).

2ndQuadrant Updates