PG Phriday: Crazy Correlated Column Crusade

For a long time, the Postgres query planner has sported a huge blinking neon blind-spot that frustrated and enraged DBAs throughout the universe to a level just shy of murderous...
July 14, 2017

News and Roadmap from Postgres-XL 10

We expect Postgres-XL 10 to be released in the next few months, with the new features of partitioning and logical replication. You’ll be able to load Postgres-XL directly from PostgreSQL...
July 05, 2017

Logical Replication in PostgreSQL 10

PostgreSQL 10 is getting close to its first beta release and it will include the initial support for logical replication, which is was written primarily by me and committed by...
April 28, 2017

Traceable commit for PostgreSQL 10

PostgreSQL 10 now supports finding out the status of a recent transaction for recovery after network connection loss or crash. Recovery from indeterminate COMMIT If there was a COMMIT “in...
April 05, 2017

XMLTABLE in PostgreSQL

I just committed a patch by Pavel Stěhule that adds the XMLTABLE functionality to PostgreSQL 10. XMLTABLE is a very useful feature dictated by the SQL/XML standard, that lets you...
March 08, 2017

PostgreSQL 10 Roadmap

At the PostgreSQL developer meeting we discussed putting up everybody’s roadmap projects in one place: http://wiki.postgresql.org/wiki/PostgreSQL10_Roadmap. 2ndQuadrant PostgreSQL Roadmap Projects Logical Replication Use Case: Upgrade Use Case: Partial database replication...
August 02, 2016