Hi Hackers,
I checked if there is update transaction on master table involved in
partition.
Postgresql takes RowExclusiveLock on all partition tables.
constraint exclusion is set to on.
My question is why it locks on all partition tables instead only one
partition tables where data is resides?
Feel free to ask if any further information is required .
--
Thanks and Regards,
Sachin Kotwal