Re: Invisible Indexes - Mailing list pgsql-hackers

From Peter Geoghegan
Subject Re: Invisible Indexes
Date
Msg-id CAH2-WznxfM4hgErzgHTwxqDj-++s9TRMthsXzP2SwmySi+cHEg@mail.gmail.com
Whole thread Raw
In response to Re: Invisible Indexes  (Euler Taveira <euler@timbira.com.br>)
List pgsql-hackers
On Tue, Jun 19, 2018 at 12:22 PM, Euler Taveira <euler@timbira.com.br> wrote:
> If we want to test the effect of disabling an index, we could set GUC
> only on the current session. DDL will make the index invisible
> immediately. Things can go worse after that. I prefer the former. It
> is more conservative but could confuse users if the effect is not
> immediate (few words could explain cached plans x invisible indexes).

If we're going to go that way, then we better not call them invisible
indexes. Invisible indexes are generally understood to be indexes that
are "invisible" to everyone -- not just the current session.

-- 
Peter Geoghegan


pgsql-hackers by date:

Previous
From: Euler Taveira
Date:
Subject: Re: Invisible Indexes
Next
From: Bruce Momjian
Date:
Subject: Re: Add necessary package list to ldap TAP's README