Re: Proposal to Enable/Disable Index using ALTER INDEX

Поиск
Список
Период
Сортировка
От David Rowley
Тема Re: Proposal to Enable/Disable Index using ALTER INDEX
Дата
Msg-id CAApHDvrJbghFBC7TD=qkw0wh=qaEQPnmd0jAq0RhHghtjmWNzQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Proposal to Enable/Disable Index using ALTER INDEX  (Vinícius Abrahão <vinnix.bsd@gmail.com>)
Список pgsql-hackers
On Sat, 12 Oct 2024 at 22:41, Vinícius Abrahão <vinnix.bsd@gmail.com> wrote:
> You are going to disable the index but not the update of it? Why? Does it imply that when you are going to re-enable
ityou are going to recreate it? 

It might be worth you reading the discussion and proposed patches. I
think either of those would answer your questions.

I don't recall anyone ever proposing that re-enabling the index would
result in it having to be rebuilt. If that was a requirement, then I'd
say there does not seem much point in the feature. You might as well
just drop the index and recreate it if you change your mind.

David



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