> 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