Postgres Pro
Downloads
Home   >   mailing lists

Why postgres take RowExclusiveLock on all partition - Mailing list pgsql-hackers

From Sachin Kotwal
Subject Why postgres take RowExclusiveLock on all partition
Date
Msg-id CA+N_YAfwPK_Xsf6+31WYxAi8M-uHMWe2wvK-8RsLddAWs2Gpuw@mail.gmail.com
Whole thread Raw
Responses Re: Why postgres take RowExclusiveLock on all partition  (Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>)
List pgsql-hackers
Tree view
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

pgsql-hackers by date:

Previous
From: Masahiko Sawada
Date:
Subject: Re: Block level parallel vacuum WIP
Next
From: Amit Kapila
Date:
Subject: README of hash index