Linux Kernel & OS

PostgreSQL 19.0 ships with parallel index vacuuming, disabled-by-default JIT

Key Takeaway

PostgreSQL 19.0 disables JIT compilation by default due to unreliable cost estimates while adding parallel index vacuuming and automatic I/O worker adjustment.

Summary

PostgreSQL 19.0 has released after a delayed schedule, with developers attributing the slip to an influx of AI and LLM-generated bug reports that strained triage resources. The release introduces workload management simplifications, distributed data handling improvements through logical replication of sequence values, and multiple performance-focused changes targeting large-scale deployments.

Key functional additions include parallel worker support for index vacuuming in autovacuum, enhanced foreign table query performance, new INSERT ... ON CONFLICT DO SELECT syntax, faster foreign key checks, and dynamic adjustment of I/O worker counts. Server-side SNI support has also been added. Notably, JIT compilation is now disabled by default because PostgreSQL's cost estimates for when JIT would be beneficial proved unreliable; administrators running analytical workloads must now manually enable it.

What changes in PostgreSQL 19.0

  • Autovacuum parallelization: Index vacuuming can now use parallel workers, reducing maintenance overhead on large tables.
  • I/O worker scaling: The default "worker" I/O method automatically adjusts its worker count rather than using fixed configuration.
  • JIT disabled by default: Just-In-Time compilation is turned off due to unreliable cost-model estimates; manual enablement is recommended for analytical query workloads.
  • Foreign data improvements: Query performance on foreign tables is improved, and foreign key check performance has been optimized.
  • Server-side SNI: The server now supports Server Name Indication for TLS connections, aiding multi-tenant and proxy deployments.

Why it matters

Database administrators and Linux distribution packagers will need to evaluate whether existing deployments benefit from manually re-enabling JIT, particularly for OLAP workloads. The autovacuum and I/O worker improvements reduce operational tuning burden for high-throughput PostgreSQL instances running on cloud and bare-metal Linux servers. Distribution maintainers should anticipate packaging this release for upcoming distro cycles, while the AI-generated bug report phenomenon may signal broader project sustainability concerns for core open-source infrastructure.

What to do

  • Administrators running large analytical queries should manually enable JIT compilation.
  • Users can download PostgreSQL 19.0 via PostgreSQL.org.

Original reference: www.phoronix.com →