Strange behavior with pg_locks and partitioning
От
Josh Berkus
Тема
Strange behavior with pg_locks and partitioning
Дата
Msg-id
4FDB65DE.2000802@agliodbs.com
Список
Дерево обсуждения
Strange behavior with pg_locks and partitioning Josh Berkus <josh@agliodbs.com>
Re: Strange behavior with pg_locks and partitioning Robert Haas <robertmhaas@gmail.com>
Re: Strange behavior with pg_locks and partitioning Josh Berkus <josh@agliodbs.com>
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 every partition. However, these rowexclusivelocks have no page or tuple reference; it's a RowExclusiveLock with no row. Is this intentional? -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com
В списке pgsql-hackers по дате отправления