Media Summary: Autovacuum was a black box. You saw bloat. You saw dead tuples. But WHY did "Where is the lock contention?" "I don't know. Somewhere." For years, For 20 years, autovacuum was a black box. You tuned. You hoped. You prayed.
Postgresql 19 Stop Guessing Which - Detailed Analysis & Overview
Autovacuum was a black box. You saw bloat. You saw dead tuples. But WHY did "Where is the lock contention?" "I don't know. Somewhere." For years, For 20 years, autovacuum was a black box. You tuned. You hoped. You prayed. For years, pg_stats could tell you a table's name, but not its identity. Today, we're going to talk about four specific improvements made in Nikolay and Michael discuss pg_stat_statements — why everyone should use it, but also some downsides! Here are links to a few ...
