avoid bloat from CREATE INDEX CONCURRENTLY

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

Responses

Browse pgsql-hackers by date

  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