2ndQuadrant is now part of EDB

Bringing together some of the world's top PostgreSQL experts.

2ndQuadrant | PostgreSQL
Mission Critical Databases
  • Contact us
  • EN
    • FR
    • IT
    • ES
    • DE
    • PT
  • Support & Services
  • Products
  • Downloads
    • Installers
      • Postgres Installer
      • 2UDA – Unified Data Analytics
    • Whitepapers
      • Business Case for PostgreSQL Support
      • Security Best Practices for PostgreSQL
    • Case Studies
      • Performance Tuning
        • BenchPrep
        • tastyworks
      • Distributed Clusters
        • ClickUp
        • European Space Agency (ESA)
        • Telefónica del Sur
        • Animal Logic
      • Database Administration
        • Agilis Systems
      • Professional Training
        • Met Office
        • London & Partners
      • Database Upgrades
        • Alfred Wegener Institute (AWI)
      • Database Migration
        • International Game Technology (IGT)
        • Healthcare Software Solutions (HSS)
        • Navionics
  • Postgres Learning Center
    • Webinars
      • Upcoming Webinars
      • Webinar Library
    • Whitepapers
      • Business Case for PostgreSQL Support
      • Security Best Practices for PostgreSQL
    • Blog
    • Training
      • Course Catalogue
    • Case Studies
      • Performance Tuning
        • BenchPrep
        • tastyworks
      • Distributed Clusters
        • ClickUp
        • European Space Agency (ESA)
        • Telefónica del Sur
        • Animal Logic
      • Database Administration
        • Agilis Systems
      • Professional Training
        • Met Office
        • London & Partners
      • Database Upgrades
        • Alfred Wegener Institute (AWI)
      • Database Migration
        • International Game Technology (IGT)
        • Healthcare Software Solutions (HSS)
        • Navionics
    • Books
      • PostgreSQL 11 Administration Cookbook
      • PostgreSQL 10 Administration Cookbook
      • PostgreSQL High Availability Cookbook – 2nd Edition
      • PostgreSQL 9 Administration Cookbook – 3rd Edition
      • PostgreSQL Server Programming Cookbook – 2nd Edition
      • PostgreSQL 9 Cookbook – Chinese Edition
    • Videos
    • Events
    • PostgreSQL
      • PostgreSQL – History
      • Who uses PostgreSQL?
      • PostgreSQL FAQ
      • PostgreSQL vs MySQL
      • The Business Case for PostgreSQL
      • Security Information
      • Documentation
  • About Us
    • About 2ndQuadrant
    • 2ndQuadrant’s Passion for PostgreSQL
    • News
    • Careers
    • Team Profile
  • Blog
  • Menu Menu
You are here: Home1 / News2 / October 18, 2018 – 2ndQuadrant contributes major features to PostgreSQL...

2ndQuadrant contributes major features to PostgreSQL 11

Enterprise features to enhance performance and improve analytics included in release

Oxford, England, October 18, 2018 — The PostgreSQL Global Development Group today announced the release of PostgreSQL 11, another major milestone for the project and PostgreSQL community. Some of the most notable features in this release have been developed by members of the 2ndQuadrant team, which has proudly contributed to the PostgreSQL project consistently for the past 15+ years.

This release presents important improvements in partitioning and parallelism – two critical areas for any relational database system – which are specifically beneficial for large analytical databases.

Parallelism has been enhanced, providing faster execution and the ability to create indexes in parallel. Partitioning advancements now produce even more rapid results when performing a search and simplify the management of partition tables, making analytics much easier.

“The PostgreSQL project continues to evolve rapidly with improvements for enterprise use. 2ndQuadrant has developed major enterprise features – such as PROCEDUREs with server-side transactions – based on client requirements, then fed back into the community for wider use.” states Simon Riggs, founder and CEO of 2ndQuadrant.

As major contributors and historical thought leaders of the PostgreSQL project, the 2ndQuadrant team is excited about this release, and has many notable contributions in terms of both features and bug fixes. Some of the major contributions by 2ndQuadrant are listed below:

  • Implementation of SQL procedures, including transaction control. Transactions can be started and committed in PL/pgSQL, PL/Perl, PL/Python and PL/Tcl procedures, as well as via SPI – Peter Eisentraut
  • Allow ALTER TABLE to add a column with a non-null default without a table rewrite – Andrew Dunstan / Serge Rielau
  • Enable index creation on partitioned tables, with automatic propagation to partitions – Álvaro Herrera
  • Replicate TRUNCATE activity when using logical replication – Simon Riggs / Marco Nenciarini / Peter Eisentraut
  • Reduce WAL retention to span one checkpointWAL segment rather than two – Simon Riggs
  • Allow replication slots to be advanced programmatically, alongside consumption  by subscribers – Petr Jelínek

2ndQuadrant has also worked actively with fellow members of the PostgreSQL community to contribute the following feature:

  • Making partition elimination faster and improve its applicability – David Rowley / Amit Langote / Beena Emerson / Dilip Kumar

PostgreSQL has been gaining traction with every release; interest and usage by large enterprises worldwide is growing exponentially due to the robust capabilities it provides. 2ndQuadrant intends to continue their active contributions in development and supports the overall growth of PostgreSQL.

To learn more about PostgreSQL and its scalable business benefits, attend the 2ndQuadrant PostgreSQL Conference 2018 being held December 4 – 5 in Chicago.

Recent Posts

  • Random Data December 3, 2020
  • Webinar: COMMIT Without Fear – The Beauty of CAMO [Follow Up] November 13, 2020
  • Full-text search since PostgreSQL 8.3 November 5, 2020
  • Random numbers November 3, 2020
  • Webinar: Best Practices for Bulk Data Loading in PostgreSQL [Follow Up] November 2, 2020

Support & Services

24/7 Production Support

Developer Support

Remote DBA for PostgreSQL

PostgreSQL Database Monitoring

PostgreSQL Health Check

PostgreSQL Performance Tuning

Database Security Audit

Upgrade PostgreSQL

PostgreSQL Migration Assessment

Migrate from Oracle to PostgreSQL

Products

HA Postgres Clusters

Postgres-BDR®

2ndQPostgres

pglogical

repmgr

Barman

Postgres Cloud Manager

SQL Firewall

Postgres-XL

OmniDB

Postgres Installer

2UDA

Postgres Learning Center

Introducing Postgres

Blog

Webinars

Books

Videos

Training

Case Studies

Events

About Us

About 2ndQuadrant

What does 2ndQuadrant Mean?

News

Careers 

Team Profile

© 2ndQuadrant Ltd. All rights reserved. | Privacy Policy
  • Twitter
  • LinkedIn
  • Facebook
  • Youtube
  • Mail
Scroll to top
×