Re: How to diagnose max_locks_per_transaction is about to be exhausted?

From: Alexey Bashtanov <bashtanov(at)imap(dot)cc>
To: Kevin Grittner <kgrittn(at)ymail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to diagnose max_locks_per_transaction is about to be exhausted?
Date: 2015-04-01 14:17:04
Message-ID: 551BFDE0.4080101@imap.cc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 01.04.2015 17:09, Kevin Grittner wrote:
>
> I think the "distinct" reference is because if one connection takes
> out the same lock on the same object (e.g., a table) you don't need
> to count it more than once. The pg_locks view only shows it once
> anyway.
Hmm, pg_locks surely shows two lines for the locks on the same object
when the pids or the granted differ.

Alexey Bashtanov

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Steven Erickson 2015-04-01 14:21:48 Re: partitoning expert : Partitonning with specialization of one column type
Previous Message Kevin Grittner 2015-04-01 14:09:57 Re: How to diagnose max_locks_per_transaction is about to be exhausted?