max_locks_per_transaction v18

From: James Pang <jamespang886(at)gmail(dot)com>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: max_locks_per_transaction v18
Date: 2025-08-18 03:12:57
Message-ID: CAHgTRffJTS+p=z2BK2GxTUqh6_-f0adGbvJQpeN1VbSWq+ThDA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

experts,
We are planning to database upgrade, and evaluate PGv18 as next new
major version. Based on new release notes, one question about, "Improve the
locking performance of queries that access many relations ".
new share_lock_table size is based on max_locks_per_transaction, our
production databases have 8k-10k connections, and existing PGV14 stable
running there long time. Is it possible to get a new GUC instead of
reusing "max_locks_per_transaction", so we can more flexible control on our
production environment, for example, we want to keep similar value as
existing "shared_lock_table" size related, and separate control of
"max_locks_per_transaction".

Thanks,

James

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message jian he 2025-08-18 04:09:12 Re: ALTER DOMAIN ADD NOT NULL NOT VALID
Previous Message Fujii Masao 2025-08-18 02:55:02 Re: Make pgoutput documentation easier to find