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

Поиск
Список
Период
Сортировка
От Renato Oliveira
Тема Re: [GENERAL] How Many PG_Locks are considered too many
Дата
Msg-id 11A711B8-3A31-4F21-BA53-9854A320F338@cantabcapital.com
обсуждение исходный текст
Ответ на Re: [GENERAL] How Many PG_Locks are considered too many  (Merlin Moncure <mmoncure@gmail.com>)
Список pgsql-admin
Thank you appreciated

Sent from my iPhone

> On 30 Jul 2015, at 20:05, Merlin Moncure <mmoncure@gmail.com> wrote:
>
>> 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 по дате отправления:

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