PostgreSQL 19 has been released, featuring significant improvements in operational control and performance. Key new features include 'WAIT FOR LSN' for read-your-writes consistency on replicas, a new 'REPACK' command to reclaim space without blocking reads and writes, and query plan advice for stabilizing performance. The release was delayed due to an influx of AI-related bug reports and security issues, but the final version is now available on platforms like Lakebase. AI
IMPACT The release was delayed due to AI-related bug reports, highlighting AI's growing impact on software development workflows.
RANK_REASON Release of a new major version of a widely-used open-source database system. [lever_c_demoted from significant: ic=4 ai=0.4]
Read on Mastodon — mastodon.social →
- Phoronix
- PostgreSQL
- PostgreSQL 19
- .claude
- Datasette
- MediaWiki
- MySQL
- Pyodide
- Qwen 3.8-27B
- WAIT FOR LSN
- Lakebase
- pg_repack
- VACUUM FULL
AI-generated summary · Google Gemini · from 4 sources. How we write summaries →