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

From Merlin Moncure
Subject Re: [GENERAL] How Many PG_Locks are considered too many
Date
Msg-id CAHyXU0ytTO0CmR=-1nrzm=y9zwvfp_Q28-t06RHtJL8VQQTnsw@mail.gmail.com
Whole thread Raw
In response to Re: How Many PG_Locks are considered too many  (John Scalia <jayknowsunix@gmail.com>)
Responses Re: [GENERAL] How Many PG_Locks are considered too many  (Renato Oliveira <Renato.Oliveira@cantabcapital.com>)
List 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 by date:

Previous
From: John Scalia
Date:
Subject: Re: Autovacuum behavior
Next
From: Alvaro Herrera
Date:
Subject: Re: Autovacuum behavior