Re: Comment on max_locks_per_transaction - Mailing list pgsql-docs

From Jeff Davis
Subject Re: Comment on max_locks_per_transaction
Date
Msg-id 1339788314.16772.3.camel@sussancws0025
Whole thread Raw
In response to Comment on max_locks_per_transaction  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Comment on max_locks_per_transaction
List 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 by date:

Previous
From: Josh Berkus
Date:
Subject: Comment on max_locks_per_transaction
Next
From: Josh Berkus
Date:
Subject: Re: Comment on max_locks_per_transaction