On Tue, Jun 19, 2018 at 12:22 PM, Euler Taveira <eu...@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