temporarily deactivate an index

Поиск
Список
Период
Сортировка
От Viktor Rosenfeld
Тема temporarily deactivate an index
Дата
Msg-id 788F92AD-B6E7-426D-9D4B-314CA7806BD5@informatik.hu-berlin.de
обсуждение исходный текст
Ответы Re: temporarily deactivate an index  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Список pgsql-general
Hi,

I'm experimenting with different indexes to speed up my queries and I
was wondering if it is possible to temporarily deactivate an index, so
it won't be considered in the evaluation of query plans.  The reason
is that dropping and then rebuilding an index takes up time which I
would rather not wait.

I couldn't find a command to do that, but I'm guessing that it should
be possible by manipulating a structure in the catalog?

Thanks,
Viktor

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

Предыдущее
От: "Adam Rich"
Дата:
Сообщение: Re: IN vs EXISTS
Следующее
От: Jeremy Harris
Дата:
Сообщение: Re: when to reindex?