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 – Add %x to default PROMPT1 and PROMPT2 in psql

On 12nd of February 2020, Michael Paquier committed patch: Add %x to default PROMPT1 and PROMPT2 in psql   %d can be used to track if the current connection is in a transaction block or not, and adding it by default to the prompt has the advantage to not need a modification of .psqlrc, something … Continue reading “Waiting for PostgreSQL 13 – Add %x to default PROMPT1 and PROMPT2 in psql”

Waiting for PostgreSQL 13 – Add functions gcd() and lcm() for integer and numeric types.

On 25th of January 2020, Dean Rasheed committed patch: Add functions gcd() and lcm() for integer and numeric types.   These compute the greatest common divisor and least common multiple of a pair of numbers using the Euclidean algorithm.   Vik Fearing, reviewed by Fabien Coelho.   Discussion: https://postgr.es/m/adbd3e0b-e3f1-5bbc-21db-03caf1cef0f7@2ndquadrant.com

Waiting for PostgreSQL 13 – Allow vacuum command to process indexes in parallel.

On 20th of January 2020, Amit Kapila committed patch: Allow vacuum command to process indexes in parallel.   This feature allows the vacuum to leverage multiple CPUs in order to process indexes. This enables us to perform index vacuuming and index cleanup with background workers. This adds a PARALLEL option to VACUUM command where the … Continue reading “Waiting for PostgreSQL 13 – Allow vacuum command to process indexes in parallel.”

Waiting for PostgreSQL 13 – Allow sampling of statements depending on duration

On 6th of November 2019, Tomas Vondra committed patch: Allow sampling of statements depending on duration   This allows logging a sample of statements, without incurring excessive log traffic (which may impact performance). This can be useful when analyzing workloads with lots of short queries.   The sampling is configured using two new GUC parameters: … Continue reading “Waiting for PostgreSQL 13 – Allow sampling of statements depending on duration”

Waiting for PostgreSQL 13 – pgbench: add –partitions and –partition-method options.

On 3rd of October 2019, Amit Kapila committed patch: pgbench: add –partitions and –partition-method options.   These new options allow users to partition the pgbench_accounts table by specifying the number of partitions and partitioning method. The values allowed for partitioning method are range and hash.   This feature allows users to measure the overhead of … Continue reading “Waiting for PostgreSQL 13 – pgbench: add –partitions and –partition-method options.”