hard20 pts · first answer countstransactionspostgresql

Locks held by nobody

A table stays locked and vacuum cannot clean anything, but no session in pg_stat_activity holds the lock. pg_prepared_xacts lists a transaction from 2 days ago. What is going on?

A.A two-phase commit was prepared but never committed or rolled back; it keeps its locks and snapshot until you run COMMIT PREPARED or ROLLBACK PREPAREDB.It is a harmless leftover; restarting the server removes itC.pg_prepared_xacts lists prepared statements, which hold no locksD.Autovacuum created it and will finish it soon

← Restore takes longer than the RTO Faster commits with a durability cost →