Horton

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

Sami Imseih <samimseih@gmail.com>

View thread
From: Sami Imseih <samimseih@gmail.com>
To: David Rowley <dgrowleyml@gmail.com>
Cc: Robert Treat <rob@xzilla.net>, Shayon Mukherjee <shayonj@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-07-22T23:04:50Z
Lists: pgsql-hackers 
> Now wondering if it would be better to spend the effort looking at
> pg_hint_plan and seeing how hard it would be to get global hints added
> which are applied to all queries, and then add a way to disable use of
> a named index. (I don't have any experience with that extension other
> than looking at the documentation)

Regardless of what comes out of this thread, pg_hint_plan supporting
a NoIndexScan hint that takes in an index name, and not only a relname
is needed. I plan on taking that up there.

--

Sami