| From: | Sergei Kornilov <sk(at)zsrv(dot)org> |
|---|---|
| To: | PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Lock level of create table partition of |
| Date: | 2020-12-17 12:41:48 |
| Message-ID: | 1851241608207472@mail.yandex.ru |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Amit Kapila | 2020-12-17 12:49:09 | Re: [HACKERS] logical decoding of two-phase transactions |
| Previous Message | Hou, Zhijie | 2020-12-17 12:08:41 | RE: [PATCH] postgres_fdw connection caching - cause remote sessions linger till the local session exit |