Practical maximum max_locks_per_transaction?

Поиск
Список
Период
Сортировка
От Ron
Тема Practical maximum max_locks_per_transaction?
Дата
Msg-id fa76c81e-723f-01ab-9155-927c549c79ec@gmail.com
обсуждение исходный текст
Ответы Re: Practical maximum max_locks_per_transaction?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
v9.6.24 (being retired next year)

https://www.postgresql.org/docs/9.6/runtime-config-locks.html

"The default, 64, has historically proven sufficient, but you might need to raise this value if you have queries that touch many different tables in a single transaction, e.g., query of a parent table with many children."

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.

--
Angular momentum makes the world go 'round.

В списке pgsql-general по дате отправления:

Предыдущее
От: Andrus
Дата:
Сообщение: How to create hot standby of Postgres 12/Debian 10.3 in Windows 11
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Practical maximum max_locks_per_transaction?