Re: Is there a way to temporarily disable a index

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Is there a way to temporarily disable a index
Дата
Msg-id 3154.1405091241@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Is there a way to temporarily disable a index  (David G Johnston <david.g.johnston@gmail.com>)
Ответы Re: Is there a way to temporarily disable a index  (Andres Freund <andres@2ndquadrant.com>)
Re: Is there a way to temporarily disable a index  (Michael Banck <mbanck@gmx.net>)
Список pgsql-hackers
David G Johnston <david.g.johnston@gmail.com> writes:
> Benedikt Grundmann wrote
>> That is it possible to tell the planner that index is off limits i.e.
>> don't ever generate a plan using it?

> Catalog hacking could work but not recommended (nor do I know the proper
> commands and limitations).  Do you need the database/table to accept writes
> during the testing period?

Hacking pg_index.indisvalid could work, given a reasonably recent PG.
I would not try it in production until I'd tested it ;-)
        regards, tom lane



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Allowing NOT IN to use ANTI joins
Следующее
От: Andres Freund
Дата:
Сообщение: Re: Is there a way to temporarily disable a index