From: Ron <ronljohnsonjr@gmail.com>
To: pgsql-general@lists.postgresql.org
Subject: Re: Practical maximum max_locks_per_transaction?
Date: Sat, 26 Nov 2022 01:33:15 -0600
Message-ID: <f2bdc35f-4b8e-c00b-e257-4717be37514f@gmail.com> (raw)
In-Reply-To: <25925.1669420577@sss.pgh.pa.us>
References: <fa76c81e-723f-01ab-9155-927c549c79ec@gmail.com>
<25925.1669420577@sss.pgh.pa.us>
On 11/25/22 17:56, Tom Lane wrote:
> Ron <ronljohnsonjr@gmail.com> writes:
>> How "raised" is too raised? I just had to increase
>> max_locks_per_transaction from 640 to 1024 on an instance with many child
>> tables and against which is run many large reports. Another instance has
>> zero children, but had to increase the value to 1280 to prevent reports from
>> failing.
> max_locks_per_transaction in isolation means nothing. What counts
> is the product max_locks_per_transaction * max_connections, which is
> (more or less) the number of slots allocated in the shared lock table.
>
> Having said that, you can probably make it as big as you want
> on any reasonably modern machine. I wouldn't blink at a few
> million locktable entries, at least not on 64-bit hardware.
Really good to know. I wonder how that can be worded in the documentation.
--
Angular momentum makes the world go 'round.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-general@postgresql.org
Cc: ronljohnsonjr@gmail.com
Subject: Re: Practical maximum max_locks_per_transaction?
In-Reply-To: <f2bdc35f-4b8e-c00b-e257-4717be37514f@gmail.com>
References: <fa76c81e-723f-01ab-9155-927c549c79ec@gmail.com> <25925.1669420577@sss.pgh.pa.us> <f2bdc35f-4b8e-c00b-e257-4717be37514f@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox