| From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
|---|---|
| To: | Pg Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | document lock obtained for FKs during detach |
| Date: | 2021-03-25 18:02:44 |
| Message-ID: | 20210325180244.GA12738@alvherre.pgsql |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
I failed to document the lock acquired on tables that reference the
partitioned table that we're detaching a partition from. This patch
(proposed for backpatch to 12, where that feature was added) fixes that
problem.
Noticed the omission a week ago while working out some details of
concurrent detach.
--
Álvaro Herrera 39°49'30"S 73°17'W
"It takes less than 2 seconds to get to 78% complete; that's a good sign.
A few seconds later it's at 90%, but it seems to have stuck there. Did
somebody make percentages logarithmic while I wasn't looking?"
http://smylers.hates-software.com/2005/09/08/1995c749.html
| Attachment | Content-Type | Size |
|---|---|---|
| 0001-Document-lock-obtained-during-partition-detach.patch | text/x-diff | 1.2 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2021-03-25 18:07:27 | Re: making update/delete of inheritance trees scale better |
| Previous Message | Andres Freund | 2021-03-25 17:49:55 | Re: shared memory stats: high level design decisions: consistency, dropping |