On Sat, Aug 02, 2025 at 03:09:19PM -0400, Shayon Mukherjee wrote: > Per this plan, this would mean that pg_hint_plan would need to > support index-level hints, and it’s not a massive / impossible > task. But it also means that both systems aren't fighting/overriding > each other or making it difficult for users to understand when > exactly an index is being used or not. Ultimately, this would also > mean that `ALTER INDEX INVISIBLE` is a one-way door, and there is > only one way to control index visibility in core, which makes sense > to me.
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. -- Michael
signature.asc
Description: PGP signature
