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 18 – Add function to get memory context stats for processes

On 8th of April 2025, Daniel Gustafsson committed patch: Add function to get memory context stats for processes   This adds a function for retrieving memory context statistics and information from backends as well as auxiliary processes. The intended usecase is cluster debugging when under memory pressure or unanticipated memory usage characteristics.   When calling … Continue reading “Waiting for PostgreSQL 18 – Add function to get memory context stats for processes”

Waiting for PostgreSQL 18 – Allow NOT NULL constraints to be added as NOT VALID

On 7th of April 2025, Álvaro Herrera committed patch: Allow NOT NULL constraints to be added as NOT VALID   This allows them to be added without scanning the table, and validating them afterwards without holding access exclusive lock on the table after any violating rows have been deleted or fixed.   Doing ALTER TABLE … Continue reading “Waiting for PostgreSQL 18 – Allow NOT NULL constraints to be added as NOT VALID”

Waiting for PostgreSQL 18 – Non text modes for pg_dumpall, correspondingly change pg_restore

On 4th of April 2025, Andrew Dunstan committed patch: Non text modes for pg_dumpall, correspondingly change pg_restore   pg_dumpall acquires a new -F/–format option, with the same meanings as pg_dump. The default is p, meaning plain text. For any other value, a directory is created containing two files, globals.data and map.dat. The first contains SQL … Continue reading “Waiting for PostgreSQL 18 – Non text modes for pg_dumpall, correspondingly change pg_restore”

Waiting for PostgreSQL 18 – Allow parallel CREATE INDEX for GIN indexes

On 3rd of March 2025, Tomas Vondra committed patch: Allow parallel CREATE INDEX for GIN indexes   Allow using parallel workers to build a GIN index, similarly to BTREE and BRIN. For large tables this may result in significant speedup when the build is CPU-bound.   The work is divided so that each worker builds … Continue reading “Waiting for PostgreSQL 18 – Allow parallel CREATE INDEX for GIN indexes”

Waiting for PostgreSQL 18 – Allow EXPLAIN to indicate fractional rows.

On 21st of February 2025, Robert Haas committed patch: Allow EXPLAIN to indicate fractional rows.   When nloops > 1, we now display two digits after the decimal point, rather than none. This is important because what we print is actually planstate->instrument->ntuples / nloops, and sometimes what you want to know is planstate->instrument->ntuples. You can … Continue reading “Waiting for PostgreSQL 18 – Allow EXPLAIN to indicate fractional rows.”