Skip to content

PostgreSQL 19 ships, adding pg_plan_advice query hints

The new major version is generally available, with an officially supported way to pin query plans. PostgreSQL 14 reached end of life the same week.

Source: PostgreSQL

PostgreSQL 19 is now generally available, after a beta and two release candidates. RC1 already covered the online REPACK (CONCURRENTLY) mode back in October, so the feature worth a second look here is pg_plan_advice: the first officially supported way to describe, reproduce and constrain a specific query plan, something teams previously needed a third-party extension for.

Logical replication changes too. It can now switch on without restarting the server when wal_level is set to replica, and sequence values replicate alongside the data, so a failover no longer leaves sequences out of step. Autovacuum gains parallel index vacuuming and a new scoring system that prioritises whichever tables need it most.

The release lands in the same week PostgreSQL 14 reached end of life. Its final minor release, 14.25, shipped on 12 November, closing the project’s five-year support window for that version.

Why it matters: Pinning a proven plan through an upgrade no longer means reaching outside PostgreSQL’s own support surface. Anyone still running 14 is now on an unsupported major version, with no further fixes coming.

Share

Related reading

More from The Wire

All briefs