From: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
---|---|
To: | Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | avoid bloat from CREATE INDEX CONCURRENTLY |
Date: | 2017-02-28 05:23:02 |
Message-ID: | 20170228052302.r7nvt4sbnsgu6job@alvherre.pgsql |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Here's another small patch, this time from Simon Riggs. Maybe he already
posted it for this commitfest, but I didn't find it in a quick look so
here it is.
This patch reduces the amount of bloat you get from running CREATE INDEX
CONCURRENTLY by destroying the snapshot taken in the first phase, before
entering the second phase. This allows the global xmin to advance,
letting concurrent vacuum keep bloat in other tables in check.
Currently this implements the change for btree indexes only, but doing
it for other indexes should be a one-liner.
--
Álvaro Herrera
Attachment | Content-Type | Size |
---|---|---|
avoid_bloat_from_cic.v1.patch | text/plain | 3.4 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2017-02-28 05:29:44 | Re: PATCH: two slab-like memory allocators |
Previous Message | Andres Freund | 2017-02-28 05:16:30 | Re: PATCH: two slab-like memory allocators |