Re: Invisible Indexes - Mailing list pgsql-hackers

From Peter Geoghegan
Subject Re: Invisible Indexes
Date
Msg-id CAH2-Wz=V1LVEa8e3y+P1gQwj76rFR4M3jBK=NP54igPZm-h8mQ@mail.gmail.com
Whole thread Raw
In response to Re: Invisible Indexes  (David Rowley <david.rowley@2ndquadrant.com>)
Responses Re: Invisible Indexes  (David Rowley <david.rowley@2ndquadrant.com>)
List pgsql-hackers
On Wed, Jul 4, 2018 at 6:26 PM, David Rowley
<david.rowley@2ndquadrant.com> wrote:
> Or would it be insanely weird to just not allow setting or unsetting
> this invisible flag if indcheckxmin is true?  I can't imagine there
> will be many people adding an index and not wanting to use it while
> it's still being created.  I think the use case here is mostly people
> wanting to test dropping indexes before they go and remove that 1TB
> index that will take days to build again if they're wrong.

I'm surprised that that use case wasn't the first one that everyone
thought of. I actually assumed that that's what Andrew had in mind
when reading his original message. I only realized later that it
wasn't.

-- 
Peter Geoghegan


pgsql-hackers by date:

Previous
From: David Rowley
Date:
Subject: Re: Invisible Indexes
Next
From: Larry Rosenman
Date:
Subject: Re: peripatus build failures....