All,
In the course of debugging why a particular server required increasing
max_locks_per_transation, I found a peculiar behavior. If you do an
UPDATE which doesn't match any CE constraint on the parent table in an
inheritance chain, you get a RowExclusiveLock on every partition and
every index
On Fri, Jun 15, 2012 at 12:42 PM, Josh Berkus j...@agliodbs.com wrote:
In the course of debugging why a particular server required increasing
max_locks_per_transation, I found a peculiar behavior. If you do an
UPDATE which doesn't match any CE constraint on the parent table in an
inheritance
So it sounds unsurprising to me.
OK, I'll just submit a note for the docs for max_locks_per_transaction,
then.
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription: