[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 по дате отправления