query is something like this
Select *
from v_test
where acode Like 'PC%'
and rev = '0Q'
and hcm = '1'
and mcm = 'K'
where acode, rev, hcm, mcm are all indexes.
Currently this query is only using the rev and mcm for the bitmapAND.
it then does a bitmap heap scan using the acode and the hcm indexes.
I would like to try to see if forcing the planner to favour heavier usage of the indexes would yield faster results.
I've tried lowering random_page_cost(default 4) down to 2 with no change in planner.