Re: Postgres using the wrong index index

You know that you can use pg_hint_plan extension? That way you don't have to disable indexes or set session parameters.

Regards

Thanks for your response, Justin!

Here's the plan if we disable the custom_2 index. It uses the index I expect and it's much faster.

Here's a plan if we disable index scans. It uses both indexes and is much faster.

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com