Re: Invisible Indexes

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Invisible Indexes
Дата
Msg-id 31056.1529360439@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Invisible Indexes  (Andrew Dunstan <andrew.dunstan@2ndquadrant.com>)
Список pgsql-hackers
Andrew Dunstan <andrew.dunstan@2ndquadrant.com> writes:
> On 06/18/2018 06:12 PM, Tom Lane wrote:
>> Anyway, if we do it with a GUC, the user can control the scope of
>> the effects.

> 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.

I find it hard to believe that it's uglier than what you suggested...
and it also does more, and is easier to implement.

            regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: Invisible Indexes
Следующее
От: Robert Treat
Дата:
Сообщение: Re: Remove mention in docs that foreign keys on partitioned tablesare not supported