Postgres Pro
Downloads
Home   >   mailing lists

Lock level of create table partition of - Mailing list pgsql-hackers

From Sergei Kornilov
Subject Lock level of create table partition of
Date
Msg-id 1851241608207472@mail.yandex.ru
Whole thread Raw
List pgsql-hackers
Tree view 
Hello

In commit 898e5e3290a72d288923260143930fb32036c00c [1] we lowered the lock level on the parent relation. I found in
discussion[2]:
 

> David Rowley recently pointed out that we can modify
> CREATE TABLE ..  PARTITION OF to likewise not obtain AEL anymore.
> Apparently it just requires removal of three lines in MergeAttributes.

But on current HEAD "create table ... partition of" still require AccessExclusiveLock on the parent relation. It's
neccessary?

regards, Sergei

[1]: https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=898e5e3290a72d288923260143930fb32036c00c
[2]: https://www.postgresql.org/message-id/20181025202622.d3x4y4ch7m4pxwnn%40alvherre.pgsql

pgsql-hackers by date:

Previous
From: "Hou, Zhijie"
Date:
Subject: RE: [PATCH] postgres_fdw connection caching - cause remote sessions linger till the local session exit
Next
From: Amit Kapila
Date:
Subject: Re: [HACKERS] logical decoding of two-phase transactions