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

From Shayon Mukherjee
Subject Re: [PATCH] Proposal to Enable/Disable Index using ALTER INDEX
Date
Msg-id 861A8DCB-1320-40E2-8994-A76489C1A23D@gmail.com
Whole thread Raw
In response to Re: [PATCH] Proposal to Enable/Disable Index using ALTER INDEX  (Michael Paquier <michael@paquier.xyz>)
Responses Re: [PATCH] Proposal to Enable/Disable Index using ALTER INDEX
List pgsql-hackers
Hello Hackers, 

Looks like there may not be enough interest to port any functionality into core. So, just noting that I have withdrawn the patch from CommitFest[1]. Thank you for the good discussions and leanings. 


Shayon

On Aug 11, 2025, at 6:22 AM, Michael Paquier <michael@paquier.xyz> wrote:

On Mon, Aug 04, 2025 at 01:19:46PM +0900, Michael Paquier wrote:
Sami has proposed a patch for pg_hint_plan that goes in the direction
of a DisableIndex hint, which is doable even if it requires some work
inside the extension code like some refactoring:
https://github.com/ossc-db/pg_hint_plan/issues/226

So I cannot say much about this proposal for core, but for
pg_hint_plan I'm looking at adding that for the v18 release of the
module, which is planned for the end of August/beginning of September.

FWIW, I have been able to merge the patch to add support for this
DisableIndex hint in pg_hint_plan.  So at least this will give people
something to toy with even without this in-core feature.  That will be
included in next week's release, available in the version of the
module compatible with v18.
--
Michael

pgsql-hackers by date:

Previous
From: Álvaro Herrera
Date:
Subject: Re: NOT NULL NOT ENFORCED
Next
From: Dean Rasheed
Date:
Subject: Re: [PATCH] Generate random dates/times in a specified range