| 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: | 2020-05-20 18:43:05 |
| Message-ID: | 20200520184305.GA20830@alvherre.pgsql |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
On 2019-Jun-14, Pavel Luzanov wrote:
> Does it make sense to change this way?
> "Some operations require a stronger lock when using declarative partitioning
> than when using table inheritance. For example, removing a
> partition 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."
It took long -- pushed now.
Thanks for reporting
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2020-05-20 19:53:23 | Re: descriptions of pg_stat_user_functions and pg_stat_slru |
| Previous Message | Fujii Masao | 2020-05-20 18:26:27 | Re: descriptions of pg_stat_user_functions and pg_stat_slru |