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

From Peter Eisentraut
Subject Re: Proposal to Enable/Disable Index using ALTER INDEX
Date
Msg-id 5d54ff80-ddb4-4ca8-ad06-06ff09627104@eisentraut.org
Whole thread Raw
In response to Re: Proposal to Enable/Disable Index using ALTER INDEX  (David Rowley <dgrowleyml@gmail.com>)
List pgsql-hackers
On 24.09.24 02:30, David Rowley wrote:
> I understand the last discussion went down that route too. For me, it
> seems strange that adding some global variable is seen as cleaner than
> storing the property in the same location as all the other index
> properties.

It's arguably not actually a property of the index, it's a property of 
the user's session.  Like, kind of, the search path is a session 
property, not a property of a schema.

> How would you ensure no cached plans are still using the index after
> changing the GUC?

Something for the patch author to figure out. ;-)



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: CSN snapshots in hot standby
Next
From: Tom Lane
Date:
Subject: Re: Proposal to Enable/Disable Index using ALTER INDEX