hn.today

PostgreSQL 19

postgresql.org13 points1 comments
Screenshot of PostgreSQL 19

PostgreSQL 19, released November 19, 2026, adds database maintenance, replication, query-planning, and performance features. The new REPACK command reorganizes tables and reclaims disk space; its CONCURRENTLY option allows reads and writes to continue. New planner-advice extensions let users guide plan selection or apply advice automatically. Logical replication can be enabled without a restart when wal_level is replica, now replicates sequence values, and standbys gain read-your-writes consistency through WAIT. Autovacuum can process indexes in parallel and prioritize tables using a scoring system. Other changes include automatic scaling of I/O workers, faster foreign-key checks, parallel TID range scans, SIMD-accelerated text and CSV imports, and more efficient sorting and compression. New monitoring views report lock activity, recovery, repacking progress, and autovacuum details.

Moving to version 19 requires a dump and restore, pg_upgrade, or logical replication, and several changes demand preparation. RADIUS authentication and the MULE_INTERNAL encoding are removed; server-side standard_conforming_strings is now always on, and database, role, and tablespace names cannot contain carriage returns or line feeds. Existing inet/cidr indexes using btree_gist can block upgrades, while some full-text-search and fuzzy-matching indexes should be rebuilt after upgrading. MD5 passwords are deprecated and now trigger warnings; JIT is disabled by default, and max_locks_per_transaction defaults to 128. The release also changes some behavior, including empty json_array() calls returning an empty array rather than NULL, and READ ONLY transactions now retain that restriction in postgres_fdw sessions.

Read on postgresql.org1 comments on Hacker News

Summary generated by AI from the linked article. hn.today is not affiliated with Hacker News or Y Combinator.

More in Programming

The daily digest

Today's best Hacker News stories, summarized and screenshotted, one email a day.