Re: Disabling an index temporarily

Поиск
Список
Период
Сортировка
От Victor Yegorov
Тема Re: Disabling an index temporarily
Дата
Msg-id CAGnEboiBsrGee12f+UkhMzRoAjC2qWKT-8z68Df4g-2gkj1aXg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Disabling an index temporarily  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
2015-12-14 5:34 GMT+02:00 Tom Lane <tgl@sss.pgh.pa.us>:
Maybe I misunderstood, but I thought what was being discussed here is
preventing the planner from selecting an index for use in queries, while
still requiring all table updates to maintain validity of the index.

The O-ther big DBMS has `ALTER INDEX ... INVISIBLE` feature, that does exactly this.


I was thinking of a function, similar to `set_config()`, for it has `is_local` parameter, making it possible to adjust just current session or a global behavior.

`set_index(name, is_visible, is_local` perhaps?


--
Victor Y. Yegorov

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

Предыдущее
От: Chapman Flack
Дата:
Сообщение: Re: Proposal: custom compression methods
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: Proposal: custom compression methods