medium10 pts · first answer countspostgresqlmvcc

Bloat from an idle session

Dead tuples keep growing even though autovacuum runs often. pg_stat_activity shows a session "idle in transaction" for 3 days. What should you do?

A.End that session and set idle_in_transaction_session_timeout so it cannot happen againB.Increase autovacuum_max_workers to 50C.Run ANALYZE on every tableD.Lower shared_buffers

← Disk not freed after a big delete A migration froze the whole app →