Hi Hackers,

I checked if there  is update transaction on master table involved in
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

Reply via email to