Re: single-row deadlock

After upgrading from PostgreSQL 9.6 to 13 we started to experience locking issues once per week or two. This turned out to be a performance problem and reused pid-s. No deadlock.

single-row deadlock

Hi, After upgrading from PostgreSQL 9.6 to 13 we started to experience locking issues once per week or two. Replacing exclusive table lock with helper table row lock did not help. Now it seems like a single-row deadlocks can occur, which should not be possible (audit_data_lock table contains o