Re: Comment on max_locks_per_transaction

Поиск
Список
Период
Сортировка
От Jeff Davis
Тема Re: Comment on max_locks_per_transaction
Дата
Msg-id 1339788314.16772.3.camel@sussancws0025
обсуждение исходный текст
Ответ на Comment on max_locks_per_transaction  (Josh Berkus <josh@agliodbs.com>)
Ответы Re: Comment on max_locks_per_transaction  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-docs
On Fri, 2012-06-15 at 11:05 -0700, Josh Berkus wrote:
> The default, 64, has historically proven sufficient for most databases,
> but you might need to raise this value if you have clients that touch
> many different tables in a single transaction.  Databases with several
> tables with many partitions each can require raising this setting.

Is "partition" defined somewhere else in the docs?

Maybe it should say something like: "Extensive use of table inheritance
is the most common reason to increase this value from the default",
assuming that's what you meant.

Regards,
    Jeff Davis


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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Comment on max_locks_per_transaction
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: Comment on max_locks_per_transaction