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 по дате отправления
От: Robert Haas
Дата:
Сообщение: Re: sortsupport for text
От: Robert Haas
Дата:
FAQ