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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general