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
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”
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.”
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.”
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”.”
On 3rd of April 2024, Tom Lane committed patch: Invent SERIALIZE option for EXPLAIN. EXPLAIN (ANALYZE, SERIALIZE) allows collection of statistics about the volume of data emitted by a query, as well as the time taken to convert the data to the on-the-wire format. Previously there was no way to investigate this without actually … Continue reading “Waiting for PostgreSQL 17 – Invent SERIALIZE option for EXPLAIN.”
On 30th of March 2024, Dean Rasheed committed patch: Add support for MERGE … WHEN NOT MATCHED BY SOURCE. This allows MERGE commands to include WHEN NOT MATCHED BY SOURCE actions, which operate on rows that exist in the target relation, but not in the data source. These actions can execute UPDATE, DELETE, or … Continue reading “Waiting for PostgreSQL 17 – Add support for MERGE … WHEN NOT MATCHED BY SOURCE.”
On 17th of March 2024, Dean Rasheed committed patch: Add RETURNING support to MERGE. This allows a RETURNING clause to be appended to a MERGE query, to return values based on each row inserted, updated, or deleted. As with plain INSERT, UPDATE, and DELETE commands, the returned values are based on the new contents … Continue reading “Waiting for PostgreSQL 17 – Add RETURNING support to MERGE.”
On 16th of January 2024, Peter Eisentraut committed patch: Support identity columns in partitioned tables Previously, identity columns were disallowed on partitioned tables. (The reason was mainly that no one had gotten around to working through all the details to make it work.) This makes it work now. Some details on the behavior: … Continue reading “Waiting for PostgreSQL 17 – Support identity columns in partitioned tables”
On 4th of January 2024, Tom Lane committed patch: In plpgsql, allow %TYPE and %ROWTYPE to be followed by array decoration. This provides the useful ability to declare a variable that is an array of the type of some other variable or some table column. Quan Zongliang, Pavel Stehule Discussion: https://postgr.es/m/ec4523e1-9e7e-f3ef-f9ce-bafd680ad6f6@yeah.net