Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] avoid bloat from CREATE INDEX CONCURRENTLY - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [HACKERS] avoid bloat from CREATE INDEX CONCURRENTLY
Date
Msg-id 1884.1488287116@sss.pgh.pa.us
Whole thread Raw
In response to [HACKERS] avoid bloat from CREATE INDEX CONCURRENTLY  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Responses Re: [HACKERS] avoid bloat from CREATE INDEX CONCURRENTLY  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-hackers
Tree view 
Alvaro Herrera <alvherre@2ndquadrant.com> writes:
> 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,

Um ... isn't there a transaction boundary there anyway?
        regards, tom lane

pgsql-hackers by date:

Previous
From: Etsuro Fujita
Date:
Subject: [HACKERS] postgres_fdw: evaluate placeholdervars on remote server
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] Statement-level rollback