[HACKERS] Strange behavior with pg_locks and partitioning

2012-06-15 Thread Josh Berkus
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

Re: [HACKERS] Strange behavior with pg_locks and partitioning

2012-06-15 Thread Robert Haas
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

Re: [HACKERS] Strange behavior with pg_locks and partitioning

2012-06-15 Thread Josh Berkus
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: