[COMMITTERS] pgsql: Don't lock tables in RelationGetPartitionDispatchInfo.

Поиск
Список
Период
Сортировка
От Robert Haas
Тема [COMMITTERS] pgsql: Don't lock tables in RelationGetPartitionDispatchInfo.
Дата
Msg-id E1diQnR-0004Pb-1F@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
Don't lock tables in RelationGetPartitionDispatchInfo.

Instead, lock them in the caller using find_all_inheritors so that
they get locked in the standard order, minimizing deadlock risks.

Also in RelationGetPartitionDispatchInfo, avoid opening tables which
are not partitioned; there's no need.

Amit Langote, reviewed by Ashutosh Bapat and Amit Khandekar

Discussion: http://postgr.es/m/91b36fa1-c197-b72f-ca6e-56c593bae68c@lab.ntt.co.jp

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/54cde0c4c05807321d3f4bf96a97c376e3fa91cb

Modified Files
--------------
src/backend/catalog/partition.c | 55 ++++++++++++++++++++++-------------------
src/backend/executor/execMain.c | 10 +++++---
src/include/catalog/partition.h |  3 +--
3 files changed, 37 insertions(+), 31 deletions(-)


В списке pgsql-committers по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: [COMMITTERS] pgsql: Refactor validation of new partitions a little bit.
Следующее
От: Tom Lane
Дата:
Сообщение: [COMMITTERS] pgsql: Temporarily revert test case froma2b70c89ca1a5fcf6181d3c777d82e