Re: Invisible Indexes

Поиск
Список
Период
Сортировка
От Peter Geoghegan
Тема Re: Invisible Indexes
Дата
Msg-id CAH2-WznxfM4hgErzgHTwxqDj-++s9TRMthsXzP2SwmySi+cHEg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Invisible Indexes  (Euler Taveira <euler@timbira.com.br>)
Список 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 по дате отправления:

Предыдущее
От: Euler Taveira
Дата:
Сообщение: Re: Invisible Indexes
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Add necessary package list to ldap TAP's README