The PostgreSQL 19.0 open-source database is now available for download. The release was delayed by several weeks due to a surge in bug reports and security concerns linked to AI and large language model generation.
The update introduces logical replication for sequence values to enhance distributed data processing. Workload management has been simplified to facilitate easier deployment and maintenance in complex environments.
Performance improvements include parallel index cleaning via the autovacuum mechanism and optimized foreign key checks. The system now automatically adjusts the number of input/output worker processes based on current load.
New query capabilities include improved external table performance and the addition of the INSERT ... ON CONFLICT DO SELECT syntax. Server Name Indication (SNI) support has been added to improve connection routing in managed environments.
The Just-In-Time (JIT) compilation feature is now disabled by default because previous cost estimation methods were deemed unreliable. Developers suggest manually enabling JIT for large-scale analytical queries.




