Re: Comment on max_locks_per_transaction

From: Jeff Davis <pgsql(at)j-davis(dot)com>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: pgsql-docs(at)postgreSQL(dot)org
Subject: Re: Comment on max_locks_per_transaction
Date: 2012-06-15 19:25:14
Message-ID: 1339788314.16772.3.camel@sussancws0025
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Josh Berkus 2012-06-15 19:37:03 Re: Comment on max_locks_per_transaction
Previous Message Josh Berkus 2012-06-15 18:05:30 Comment on max_locks_per_transaction