> pg_locks shows exactly two types of locks: "heavy" locks (which are not
> merely relation locks but also object, tuple, extension, transaction and
> advisory locks), and predicate locks (SIReadLock) which are limited by a
> separate configuration parameter (and are not relevant in this case
> bas
> "Peter" == Peter Eisentraut writes:
Peter> max_locks_per_transactions only affects relation locks (also
Peter> known as heavy weight locks), but pg_locks also shows other
Peter> kinds of locks.
pg_locks shows exactly two types of locks: "heavy" locks (which are not
merely relation locks
On 2019-12-19 10:33, James Sewell wrote:
I have a system which is giving me the log hint to increase
max_locks_per_transaction. This is somewhat expected due to the workload
- but what I can't understand is the numbers:
Based on the docs I calculate my theoretical max loc
Hello all,
I have a system which is giving me the log hint to increase
max_locks_per_transaction. This is somewhat expected due to the workload -
but what I can't understand is the numbers:
Based on the docs I calculate my theoretical max locks as:
max_locks_per_transaction * (max_connec
