Technology

Add as a preferred source on Google

PostgreSQL 19 Adds Concurrent Table Maintenance as EDB Announces Release

EDB says support begins Nov. 19, and its Postgres AI enterprise servers are scheduled to ship with PostgreSQL 19 in February 2027.

Updated 2 min read
An engineer checks database maintenance notes in a data center operations room in the United States. (AI-generated image / EconoTimes)
An engineer checks database maintenance notes in a data center operations room in the United States. (AI-generated image / EconoTimes)

EDB said PostgreSQL 19 is generally available, bringing a table-maintenance command that can run while a database remains in use and new tools for guiding query plans. The release adds capabilities for database operators, though the PostgreSQL project’s news page still listed the second release candidate as its latest announcement when checked.

PostgreSQL’s release notes say REPACK frees storage by rearranging table data. Its concurrent mode allows reads and writes to continue during the operation. The release also introduces pg_plan_advice to guide query-planner decisions and pg_stash_advice to apply plan advice automatically.

Other additions include parallel autovacuum for table indexes, a system for prioritizing autovacuum work and logical replication of sequence values. The release notes also say logical replication can be enabled without restarting the server when wal_level is set to replica.

EDB said it will begin supporting PostgreSQL 19 on Nov. 19. Its Postgres AI enterprise servers are scheduled to ship with the new version in February 2027. To upgrade from an earlier major version, users can use dump and restore, pg_upgrade or logical replication, according to PostgreSQL’s documentation.

The PostgreSQL release team moved the planned general-availability date to Nov. 19 so fixes from a scheduled update could be included in a second release candidate. EDB’s announcement came in the project’s 30th year; PostgreSQL’s historical account dates the setup of its first public CVS server to July 8, 1996.

Related articles

View all