Waiting for PostgreSQL 10 – Logical replication

On 20th of January, Peter Eisentraut committed patch: Logical replication   – Add PUBLICATION catalogs and DDL – Add SUBSCRIPTION catalog and DDL – Define logical replication protocol and output plugin – Add logical replication workers   From: Petr Jelinek Reviewed-by: Steve Singer Reviewed-by: Andres Freund Reviewed-by: Erik Rijkers Reviewed-by: Peter Eisentraut

Waiting for PostgreSQL 10 – Add pg_sequence system catalog

On 20th of December, Peter Eisentraut committed patch: Add pg_sequence system catalog   Move sequence metadata (start, increment, etc.) into a proper system catalog instead of storing it in the sequence heap object. This separates the metadata from the sequence data. Sequence metadata is now operated on transactionally by DDL commands, whereas previously rollbacks of … Continue reading “Waiting for PostgreSQL 10 – Add pg_sequence system catalog”

Waiting for PostgreSQL 10 – Implement table partitioning.

I had two month delay related to some work, but now I can finally write about: On 7th of December, Robert Haas committed patch: Implement table partitioning.   Table partitioning is like table inheritance and reuses much of the existing infrastructure, but there are some important differences. The parent is called a partitioned table and … Continue reading “Waiting for PostgreSQL 10 – Implement table partitioning.”

Waiting for PostgreSQL 10 – postgres_fdw: Push down aggregates to remote servers.

On 21st of October, Robert Haas committed patch: postgres_fdw: Push down aggregates to remote servers.   Now that the upper planner uses paths, and now that we have proper hooks to inject paths into the upper planning process, it’s possible for foreign data wrappers to arrange to push aggregates to the remote side instead of … Continue reading “Waiting for PostgreSQL 10 – postgres_fdw: Push down aggregates to remote servers.”

Waiting for PostgreSQL 10 – Rename “pg_xlog” directory to “pg_wal”.

On 20th of October, Robert Haas committed patch: Rename "pg_xlog" directory to "pg_wal".   "xlog" is not a particularly clear abbreviation for "write-ahead log", and it sometimes confuses users into believe that the contents of the "pg_xlog" directory are not critical data, leading to unpleasant consequences. So, rename the directory to "pg_wal".   This patch … Continue reading “Waiting for PostgreSQL 10 – Rename “pg_xlog” directory to “pg_wal”.”

Waiting for PostgreSQL 13 – Support for FF1-FF6 and SSSS datetime format patterns

On 16th of September 2019, Alexander Korotkov committed two patches: First patch: Support for SSSSS datetime format pattern   SQL Standard 2016 defines SSSSS format pattern for seconds past midnight in jsonpath .datetime() method and CAST (… FORMAT …) SQL clause. In our datetime parsing engine we currently support it with SSSS name.   This … Continue reading “Waiting for PostgreSQL 13 – Support for FF1-FF6 and SSSS datetime format patterns”

How to play with upcoming, unreleased, PostgreSQL?

Lately reader of my blog asked about some detail, and then in next comment said that he doesn’t have PostgreSQL 12 (which is currently developed version of Pg) available. Well, I answered the original question, but I figured that if someone is reading my Waiting for … series, then it would make sense that such … Continue reading “How to play with upcoming, unreleased, PostgreSQL?”

Waiting for PostgreSQL 12 – Add SETTINGS option to EXPLAIN, to print modified settings.

On 3rd of April 2019, Tomas Vondra committed patch: Add SETTINGS option to EXPLAIN, to print modified settings.     Query planning is affected by a number of configuration options, and it may be crucial to know which of those options were set to non-default values. With this patch you can say EXPLAIN (SETTINGS ON) … Continue reading “Waiting for PostgreSQL 12 – Add SETTINGS option to EXPLAIN, to print modified settings.”

Waiting for PostgreSQL 12 – Support foreign keys that reference partitioned tables

On 3rd of April 2019, Alvaro Herrera committed patch: Support foreign keys that reference partitioned tables     Previously, while primary keys could be made on partitioned tables, it was not possible to define foreign keys that reference those primary keys. Now it is possible to do that.   Author: Álvaro Herrera   Discussion: https://postgr.es/m/20181102234158.735b3fevta63msbj@alvherre.pgsql

Waiting for PostgreSQL 12 – Log all statements from a sample of transactions

On 3rd of April 2019, Alvaro Herrera committed patch: Log all statements from a sample of transactions   This is useful to obtain a view of the different transaction types in an application, regardless of the durations of the statements each runs.   Author: Adrien Nayrat