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

From: Renato Oliveira <Renato(dot)Oliveira(at)cantabcapital(dot)com>
To: Merlin Moncure <mmoncure(at)gmail(dot)com>
Cc: John Scalia <jayknowsunix(at)gmail(dot)com>, Peter Eisentraut <peter_e(at)gmx(dot)net>, Forums postgresql <pgsql-general(at)postgresql(dot)org>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: [GENERAL] How Many PG_Locks are considered too many
Date: 2015-07-31 06:34:34
Message-ID: 11A711B8-3A31-4F21-BA53-9854A320F338@cantabcapital.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

Thank you appreciated

Sent from my iPhone

> On 30 Jul 2015, at 20:05, Merlin Moncure <mmoncure(at)gmail(dot)com> wrote:
>
>> On Thu, Jul 30, 2015 at 9:19 AM, John Scalia <jayknowsunix(at)gmail(dot)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
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message John Scalia 2015-07-31 12:40:33 Re: Autovacuum behavior
Previous Message Om Prakash Jaiswal 2015-07-31 04:44:27 Re: Autovacuum behavior

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2015-07-31 10:05:53 Re: conn = PQconnectdb(conninfo);
Previous Message Tatsuo Ishii 2015-07-31 00:07:01 Re: Lots of stuck queries after upgrade to 9.4