Urgent.News

What's breaking now, across hundreds of outlets.

Tech

PostgreSQL 19 Released with Online Table Repacking and Query Planning Controls

The PostgreSQL Global Development Group released PostgreSQL 19, introducing changes to database maintenance, query planning, replication, and application development. The release focuses on reducing administrative overhead and improving performance, with new tools for reorganizing tables without downtime and controlling query plans. By Robert Krzaczyński

PostgreSQL 19 has been released by the PostgreSQL Global Development Group, introducing several enhancements in database maintenance, query planning, replication, and application development. The most notable addition is the REPACK tool, which allows for the reorganization of tables without downtime, reclaiming unused space and ordering data to match an index.

This replaces the use of VACUUM FULL and CLUSTER. The release also includes pg_plan_advice and pg_stash_advice, which enable administrators to influence query plan selection and store advice for future use. Additional maintenance improvements include parallel index vacuuming, changes to autovacuum prioritization, and new monitoring views.

Query planner improvements include more efficient anti-joins and eager aggregation before joins. The release also brings new features for replication and application development, such as support for sequence values in logical replication, the WAIT FOR LSN command for read-your-writes consistency, and new SQL/JSON string methods.

Brief written by urgent.news; may contain errors — check the original.

Source: infoq.com

Read the original at infoq.com →

Report a problem with this story

More in Tech

More from Sunday 22 November →