Re: Invisible Indexes - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: Invisible Indexes
Date
Msg-id CAKFQuwbzUEEMwp0w0H0UJCXMi=+ZnWg4z86g0A+XOyquevk0kg@mail.gmail.com
Whole thread Raw
In response to Re: Invisible Indexes  (Andrew Dunstan <andrew.dunstan@2ndquadrant.com>)
List pgsql-hackers
On Mon, Jun 18, 2018 at 3:17 PM, Andrew Dunstan <andrew.dunstan@2ndquadrant.com> wrote:
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.

​On that front what's the proposed behavior for cached plans using said index?

IIUC with a GUC you'd have to force clients to establish new sessions if you wanted all queries to be affected by the new setting whereas using cache invalidation you can affect existing sessions with a catalog update.

David J.

pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: [WIP] [B-Tree] Retail IndexTuple deletion
Next
From: Michael Paquier
Date:
Subject: Re: pg_config.h.win32 missing a set of flags from pg_config.h.inadded in v11 development