Terry Fielder <terry(at)ashtonwoodshomes(dot)com> 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