Andrey Lizenko <lizenk...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
