This is a short summary. ↗ Open original to view full content
Waiting for PostgreSQL 18 – Add OLD/NEW support to RETURNING in DML queries.
from blog select * from depesz;, | ↗ original
More from select * from depesz;
Waiting for PostgreSQL 18 – Allow changing autovacuum_max_workers without restarting.
24 Jan 2025 |
original ↗
On 6th of January 2025, Nathan Bossart committed patch: Allow changing autovacuum_max_workers without restarting. This commit introduces a new parameter named autovacuum_worker_slots that controls how many autovacuum worker slots to reserve during server startup. Modifying this new parameter's value does require a server restart, but it should...
Waiting for PostgreSQL 18 – Enable BUFFERS with EXPLAIN ANALYZE by default
15 Jan 2025 |
original ↗
On 11st of December 2024, David Rowley committed patch: Enable BUFFERS with EXPLAIN ANALYZE by default The topic of turning EXPLAIN's BUFFERS option on with the ANALYZE option has come up a few times over the past few years. In many ways, doing this seems like a good idea as it may be more … Continue reading "Waiting for PostgreSQL 18 – Enable...
Waiting for PostgreSQL 18 – Support LIKE with nondeterministic collations
10 Jan 2025 |
original ↗
On 27th of November 2024, Peter Eisentraut committed patch: Support LIKE with nondeterministic collations This allows for example using LIKE with case-insensitive collations. There was previously no internal implementation of this, so it was met with a not-supported error. This adds the internal implementation and removes the error. The...
Waiting for PostgreSQL 18 – psql: Add more information about service name
6 Jan 2025 |
original ↗
On 18th of December 2024, Michael Paquier committed patch: psql: Add more information about service name This commit adds support for the following items in psql, able to show a service name, when available: - Variable SERVICE. - Substitution %s in PROMPT{1,2,3}. This relies on 4b99fed7541e, that has made the service name available … Continue...
Waiting for PostgreSQL 18 – Add UUID version 7 generation function.
31 Dec 2024 |
original ↗
On 11st of December 2024, Masahiko Sawada committed patch: Add UUID version 7 generation function. This commit introduces the uuidv7() SQL function, which generates UUID version 7 as specified in RFC 9652. UUIDv7 combines a Unix timestamp in milliseconds and random bits, offering both uniqueness and sortability. In our implementation, the...