Re: Is there a way to temporarily disable a index

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Is there a way to temporarily disable a index
Дата
Msg-id 3472.1405092008@sss.pgh.pa.us
обсуждение исходный текст
Ответ на 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  (Andres Freund <andres@2ndquadrant.com>)
Список pgsql-hackers
Andres Freund <andres@2ndquadrant.com> writes:
> On 2014-07-11 11:07:21 -0400, Tom Lane wrote:
>> Hacking pg_index.indisvalid could work, given a reasonably recent PG.
>> I would not try it in production until I'd tested it ;-)

> Works, but IIRC can cause problems at least < 9.4 because concurrent
> cache builds might miss the pg_index row...

If you're talking about SnapshotNow hazards, I think the risk would be
minimal, and probably no worse than cases that the system will cause
by itself.
        regards, tom lane



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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: Is there a way to temporarily disable a index
Следующее
От: Andres Freund
Дата:
Сообщение: Re: Is there a way to temporarily disable a index