Re: Maximum number of exclusive locks - Mailing list pgsql-general

From Tom Lane
Subject Re: Maximum number of exclusive locks
Date
Msg-id 26828.1473772864@sss.pgh.pa.us
Whole thread Raw
In response to Maximum number of exclusive locks  ("Daniel Verite" <daniel@manitou-mail.org>)
Responses Re: Maximum number of exclusive locks  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-general
"Daniel Verite" <daniel@manitou-mail.org> writes:
> Nothing to complain about, but why would the above formula
> underestimate the number of object locks actually available
> to a transaction? Isn't it supposed to be a hard cap for such
> locks?

No, it's a minimum not a maximum.  There's (intentionally) a fair amount
of slop in the initial shmem size request.  Once everything that's going
to be allocated has been allocated during postmaster startup, the rest is
available for growth of shared hash tables, which in practice means the
lock table; there aren't any other shared structures that grow at runtime.
So there's room for the lock table to grow a bit beyond its nominal
capacity.

Having said that, the amount of slop involved is only enough for a
few hundred lock entries.  Not sure how you're managing to get to
nearly 20000 extra entries.

            regards, tom lane


pgsql-general by date:

Previous
From: "Daniel Verite"
Date:
Subject: Maximum number of exclusive locks
Next
From: "Hu, Patricia"
Date:
Subject: Re: Predicting query runtime