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