From the archive
Thursday, 19 November
Folded from 36 sources that day.
Sorted by quality and by how many sources covered it, the same for everyone.
-
PostgreSQL 19 released
PostgreSQL 19 adds REPACK (CONCURRENTLY) for rewriting tables without blocking ongoing queries. It also introduces the pg_plan_advice extension for plan stability, along with several performance improvements.
-
Distributed, high-performance blob storage on SQLite
Kite replaced its unmaintained SSDB store with Blobasaur, a sharded, distributed blob server built on SQLite. It serves thousands of multi-megabyte JSON reads and writes per second at single-digit millisecond latency.
-
Your biggest tenant runs someone else's plan
A prepared statement planned from small tenants' runs can be reused for a 200x larger tenant, costing thousands of buffer reads per call. Measured on PostgreSQL 18.7 with synthetic data.
-
Squeezing tables with Postgres 19
Explains why VACUUM FULL was not enough for busy production databases and how the new concurrent table rewrite in PostgreSQL 19 addresses that. The post traces the idea back to a 2024 hackers mailing list question.
-
Researcher Demonstrates Database RCE Exploits Affecting PostgreSQL, MySQL and Oracle
Low-privilege database accounts can reach memory-corruption bugs in SQL engine code and run code on the server. Proofs of concept target PostgreSQL, MySQL and ClickHouse, with a separate Oracle chain.