PostgreSQL 19 Ships Today: REPACK, Graph Queries, and the End of VACUUM FULL

The PostgreSQL Global Development Group released PostgreSQL 19 on November 19, 2026. It's a substantial release — VACUUM FULL gets a proper replacement, graph queries land in standard SQL, and logical replication gains sequence support. Here's what actually changed.

REPACK replaces VACUUM FULL

The biggest maintenance improvement is the new REPACK command. It does what VACUUM FULL and CLUSTER do — rewrites a table on disk and reclaims space — but with a CONCURRENTLY option that keeps the table readable and writable for most of the operation. For large production tables, this is a significant operational win: you no longer need a maintenance window just to reclaim bloated space. Autovacuum also gains parallel worker support for index processing, reducing the time it holds locks on busy tables.

SQL/PGQ: graph queries in standard SQL

PostgreSQL 19 ships with SQL/PGQ support, the ISO SQL standard for property graph queries. It lets you express traversals and pattern matching over graph-structured data without leaving SQL. The syntax lets you define nodes and edges, then query them with MATCH patterns inline. If you've been storing relationship data in a relational schema and dreading recursive CTEs, this is the native alternative. Note that it was actually reverted from the beta 4 candidate and then restored — it's in the final release.

Logical replication of sequences

Sequences can now be replicated logically, using FOR ALL SEQUENCES in a CREATE PUBLICATION statement. This closes a long-standing gap in logical replication setups, where sequence values on replicas would drift from the primary and cause issues when promoting a standby. It's a quiet but meaningful change for anyone running failover setups that need replicas to be ready to become primaries without manual sequence correction.

Other notable changes

  • pg_plan_advice: A new extension for controlling query plan stability — useful when a plan regression is hurting a critical query and you need to pin it without rewriting the query.
  • GROUP BY ALL: Automatically includes all non-aggregate, non-window output columns in the GROUP BY clause, cutting down on repetitive column listing.
  • JIT off by default: JIT compilation is now disabled out of the box. It caused more overhead than benefit for most workloads. You can still enable it explicitly.
  • LZ4 as default TOAST compression: Replaces the older pglz algorithm for better compression speed.
  • Server Name Indication (SNI): The server can now present different TLS certificates based on the client's requested hostname, which simplifies multi-tenant TLS setups.

PostgreSQL 14 reaches end of life

Alongside the PostgreSQL 19 release, PostgreSQL 14 received its final minor update on November 12 and is now unsupported. If you're still running 14, it's time to plan an upgrade path.

PostgreSQL 19 is available now from the official PostgreSQL download page.