Re: Proposal to Enable/Disable Index using ALTER INDEX - Mailing list pgsql-hackers

From David Rowley
Subject Re: Proposal to Enable/Disable Index using ALTER INDEX
Date
Msg-id CAApHDvrJbghFBC7TD=qkw0wh=qaEQPnmd0jAq0RhHghtjmWNzQ@mail.gmail.com
Whole thread Raw
In response to Re: Proposal to Enable/Disable Index using ALTER INDEX  (Vinícius Abrahão <vinnix.bsd@gmail.com>)
List 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 by date:

Previous
From: Masahiko Sawada
Date:
Subject: Re: Fix for consume_xids advancing XIDs incorrectly
Next
From: David Rowley
Date:
Subject: Re: Proposal to Enable/Disable Index using ALTER INDEX