Re: ATTACH/DETACH partitions and locking

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: Pavel Luzanov <p(dot)luzanov(at)postgrespro(dot)ru>
Cc: pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Re: ATTACH/DETACH partitions and locking
Date: 2019-06-13 20:07:20
Message-ID: 20190613200720.GA18557@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-docs

On 2019-Jun-13, Pavel Luzanov wrote:

> Hello,
> According to patch[1] and after playing with v12 beta1 I think that this
> item can be dropped from "5.11.3. Implementation Using Inheritance" section
> of v12 docs:
> "Some operations require a stronger lock when using declarative partitioning
> than when using table inheritance. For example, adding or removing a
> partition to or from a partitioned table requires taking an ACCESS EXCLUSIVE
> lock on the parent table, whereas a SHARE UPDATE EXCLUSIVE lock is enough in
> the case of regular inheritance."

Hmm ... while you're correct that ALTER TABLE ATTACH PARTITION no longer
uses AccessExclusive lock, ALTER TABLE DETACH PARTITION continues to.
So we could remove the "adding to" bit of the paragraph, but not remove
it completely.

Álvaro Herrera
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to


Browse pgsql-docs by date

  From Date Subject
Next Message Daniel Gustafsson 2019-06-14 08:47:40 Formatting of warning about using ident
Previous Message PG Doc comments form 2019-06-13 19:52:57 More obvious clarification is needed about how RLS interacts with views