[HACKERS] avoid bloat from CREATE INDEX CONCURRENTLY

Поиск
Список
Период
Сортировка
Искать
От
Alvaro Herrera
Тема
[HACKERS] avoid bloat from CREATE INDEX CONCURRENTLY
Дата
Msg-id
20170228052302.r7nvt4sbnsgu6job@alvherre.pgsql
Список
Дерево обсуждения
[HACKERS] avoid bloat from CREATE INDEX CONCURRENTLY Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [HACKERS] avoid bloat from CREATE INDEX CONCURRENTLY Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] avoid bloat from CREATE INDEX CONCURRENTLY Simon Riggs <simon@2ndquadrant.com>
Re: [HACKERS] avoid bloat from CREATE INDEX CONCURRENTLY Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] avoid bloat from CREATE INDEX CONCURRENTLY Simon Riggs <simon@2ndquadrant.com>
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

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
В списке pgsql-hackers по дате отправления
От: Andres Freund
Дата:
От: Tom Lane
Дата:
FAQ