Why postgres take RowExclusiveLock on all partition

From: Sachin Kotwal <kotsachin(at)gmail(dot)com>
To: PostgreSQL Developers <pgsql-hackers(at)postgresql(dot)org>
Subject: Why postgres take RowExclusiveLock on all partition
Date: 2016-09-16 11:01:24
Message-ID: CA+N_YAfwPK_Xsf6+31WYxAi8M-uHMWe2wvK-8RsLddAWs2Gpuw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2016-09-16 11:20:53 README of hash index
Previous Message Masahiko Sawada 2016-09-16 09:56:33 Re: Block level parallel vacuum WIP