Answer
Long transactions block vacuum cleanup and cause bloat. Use timeouts, break transactions into smaller pieces, and monitor stale sessions.
Quick Answer
Long-running transactions prevent VACUUM from reclaiming dead tuples (any tuple that might be visible to the long transaction is kept). They also hold locks and cause XID age to grow. Monitor with pg_stat_activity (duration column). Set statement_timeout and lock_timeout to kill stuck queries. Set idle_in_transaction_session_timeout to kill connections stuck in idle-in-transaction state.
S
SugharaIQ Editorial Team
Verified Answer
This answer has been peer-reviewed by industry experts holding senior engineering roles to ensure technical accuracy and relevance for modern interview standards.
Want to bookmark, take notes, or join discussions?
Sign in to access all features and personalize your learning experience.
Source: SugharaIQ