Re: Invisible Indexes

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Invisible Indexes
Дата
Msg-id CAKFQuwbzUEEMwp0w0H0UJCXMi=+ZnWg4z86g0A+XOyquevk0kg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Invisible Indexes  (Andrew Dunstan <andrew.dunstan@2ndquadrant.com>)
Список 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 по дате отправления:

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Re: [WIP] [B-Tree] Retail IndexTuple deletion
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: pg_config.h.win32 missing a set of flags from pg_config.h.inadded in v11 development