Andrey Lizenko <lizenko79@gmail.com> wrote:
> does max_locks_per_transaction limit all others modes of locks by
> the same way?
In the sense that the count of all other locks must be less than
max_locks_per_transaction * max_connections, yes. Most other locks
do not persist past the end of transactions or the closing of
connections (advisory locks and locks related to prepared
transactions being edge-case exceptions). No other types of locks
have the granularity promotion -- most other locks showing in
sp_locks are on relations or transactions.
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company