Horton

Re: [PATCH] Proposal to Enable/Disable Index using ALTER INDEX

Shayon Mukherjee <shayonj@gmail.com>

View thread
From: Shayon Mukherjee <shayonj@gmail.com>
To: Michael Paquier <michael@paquier.xyz>
Cc: Sami Imseih <samimseih@gmail.com>, Robert Treat <rob@xzilla.net>, David Rowley <dgrowleyml@gmail.com>, jian he <jian.universality@gmail.com>, Gurjeet Singh <gurjeet@singh.im>, Nathan Bossart <nathandbossart@gmail.com>, pgsql-hackers@lists.postgresql.org
Date: 2025-09-08T12:15:05Z
Lists: 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. 

[1] https://commitfest.postgresql.org/patch/5274/

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