Re: [GENERAL] How Many PG_Locks are considered too many - Mailing list pgsql-admin

From Renato Oliveira
Subject Re: [GENERAL] How Many PG_Locks are considered too many
Date
Msg-id 11A711B8-3A31-4F21-BA53-9854A320F338@cantabcapital.com
Whole thread Raw
In response to Re: [GENERAL] How Many PG_Locks are considered too many  (Merlin Moncure <mmoncure@gmail.com>)
List 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 by date:

Previous
From: Om Prakash Jaiswal
Date:
Subject: Re: Autovacuum behavior
Next
From: John Scalia
Date:
Subject: Re: Autovacuum behavior