| From: | Pavel Luzanov <p(dot)luzanov(at)postgrespro(dot)ru> |
|---|---|
| To: | pgsql-docs(at)lists(dot)postgresql(dot)org |
| Subject: | ATTACH/DETACH partitions and locking |
| Date: | 2019-06-13 12:14:13 |
| Message-ID: | 642e9fbc-b832-698b-9a8f-d626afd7014d@postgrespro.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
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."
Small patch attached.
[1] ATTACH/DETACH PARTITION CONCURRENTLY
https://www.postgresql.org/message-id/flat/CAKJS1f9QjUwQrio20Pi=yCHmnouf4z3SfN8sqXaAcwREG6k0zQ(at)mail(dot)gmail(dot)com
--
-----
Pavel Luzanov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
| Attachment | Content-Type | Size |
|---|---|---|
| ddlsgml.patch | text/x-patch | 810 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | PG Doc comments form | 2019-06-13 19:52:57 | More obvious clarification is needed about how RLS interacts with views |
| Previous Message | PG Doc comments form | 2019-06-13 09:23:50 | Mistake in documentation for CREATE STATISTICS |