Re: Invisible Indexes

Andrew Dunstan <andrew.dunstan@2ndquadrant.com> writes:
> On 06/18/2018 06:12 PM, Tom Lane wrote:
>> Anyway, if we do it with a GUC, the user can control the scope of
>> the effects.

> Yeah, but Peter makes the case that people want it for global 
> experimentation. "We think we can safely drop this humungous index that 
> would take us days to rebuild, but before we do let's make it invisible 
> and run for a few days just to make sure." I guess we could do that with 
> a GUC, but it seems ugly.

I find it hard to believe that it's uglier than what you suggested...
and it also does more, and is easier to implement.

            regards, tom lane