DatenbankenPlanet PostgreSQLEnglisch (hoher Informationsgehalt bei geringem lokalem Volumen)
Datenbanken
On 6th of April 2026, Álvaro Herrera committed patch: Add CONCURRENTLY option to REPACK When this flag is specified, REPACK no longer acquires access-exclusive lock while the new copy of the table is being created; instead, it creates the…
Robert Haas’s pg_plan_advice patch set, proposed for PostgreSQL 19, is where the twenty-year argument from Part 2 has landed — or is trying to. It is not pg_hint_plan brought into core. It is a different thing, with different mechanics, a…
Introduction: Recently I was having a conversation with a DB Enthusiast, and he mentioned that when he was a fresher, he tuned an ETL/reporting query that was running for 8-10 hours via a nightly job by 1/3rd. He went to his manager,…
Every 1 KB insert in Postgres becomes ~2.5 KB of committed I/O before it's done. Here's where the multiplier comes from, and where the tuning knobs run out.