Terry Fielder <terry@xxxxxxxxxxxxxxxxxxxx> writes: > 7.4.3 Yoi. You need to think about an update. > And the records are gone from pg_locks, how much time after the deadlock > do I have before they are purged? Approximately none --- pg_locks is a live view. regards, tom lane