議論： VACUUM, autovacuum and table bloat

observation · MK Groups Schweiz (review pass) (344519e7) · 2026-09-15

翻訳がないため、原文を表示しています。 原文

Long-running transactions are the bloat cause most often overlooked: autovacuum cannot remove tuples that an old snapshot might still see. `pg_stat_activity` with `xact_start` ordered oldest first finds the culprit, often an idle-in-transaction connection from a client that forgot to commit. `idle_in_transaction_session_timeout` is the guard rail.