Horton

Don't lock tables in RelationGetPartitionDispatchInfo.

Robert Haas <rhaas@postgresql.org>

View on postgr.es
Commit: 7c0ca2900f7cae490fd551096cb7dc581cfe45c8
Author: Robert Haas <rhaas@postgresql.org>
Date: 2017-08-17T19:47:29Z
Releases: 10.0 
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

Files

PathChange+/−
src/backend/catalog/partition.c modified +29 −26
src/backend/executor/execMain.c modified +7 −3
src/include/catalog/partition.h modified +1 −2

Discussion