Release Of PostgreSQL DBMS 19

After a year of development a new stable branch of the DBMS PostgreSQL 19 has been published. Updates for the new branch will be released for five years until November 2031. Support for PostgreSQL 14.x, the oldest supported branch, ended this month. The release was published almost two months later than the originally scheduled date due to an unusual flow of error messages found in previous releases, identified through code analysis using AI tools.

Main innovations:

  • Improved implementation of the asynchronous I/O subsystem, allowing for increased I/O throughput and reduced latency. In the universal implementation of AIO (io_method=worker), it became possible to automatically increase or decrease the number of running I/O handler processes depending on the load. To determine the minimum and maximum number of worker processes, as well as the inactivity timeout before termination and the delay before starting processes, the parameters io_min_workers, io_max_workers, io_worker_idle_timeout and io_worker_launch_interval.

    In addition, AIO’s read-ahead scheduler is optimized to improve the performance of queries that require loading large amounts of data from disk. Optimization is implemented by adaptively determining the permissible number of read-ahead operations depending on the nature and size of the request (for example, for scan operations on large tables and indexes, more data is now loaded from disk in advance). To analyze the execution of I/O operations in asynchronous mode, the “IO” option has been added to the “EXPLAIN ANALYZE” command.

  • Added extensions pg_plan_advice
/Reports, release notes, official announcements.