Re: [GENERAL] How Many PG_Locks are considered too many

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: [GENERAL] How Many PG_Locks are considered too many
Дата
Msg-id CAHyXU0ytTO0CmR=-1nrzm=y9zwvfp_Q28-t06RHtJL8VQQTnsw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How Many PG_Locks are considered too many  (John Scalia <jayknowsunix@gmail.com>)
Ответы Re: [GENERAL] How Many PG_Locks are considered too many  (Renato Oliveira <Renato.Oliveira@cantabcapital.com>)
Список pgsql-admin
On Thu, Jul 30, 2015 at 9:19 AM, John Scalia <jayknowsunix@gmail.com> wrote:
> Seconding Peter on this one; it's a lot more important should one of those
> locks be hanging around, say for hours or days, not how many have come and
> gone.

Also, it's good to focus on *ungranted* locks.   Typically the only
time I care about granted locks is to find out which process is
keeping my other process getting its lock granted.

merlin


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

Предыдущее
От: John Scalia
Дата:
Сообщение: Re: Autovacuum behavior
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Autovacuum behavior