Re: How to monitor locks (max_pred_locks_per_transaction)?

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: How to monitor locks (max_pred_locks_per_transaction)?
Дата
Msg-id 1325325919.4259646.1420833897790.JavaMail.yahoo@jws10031.mail.ne1.yahoo.com
обсуждение исходный текст
Ответ на Re: How to monitor locks (max_pred_locks_per_transaction)?  (Andrey Lizenko <lizenko79@gmail.com>)
Список pgsql-general
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

В списке pgsql-general по дате отправления:

Предыдущее
От: dvlsg
Дата:
Сообщение: Re: PSQL/pgAdmin - Column Completion
Следующее
От: Michael Nolan
Дата:
Сообщение: How to analyze a slowdown in 9.3.5?