On Fri, Mar 23, 2007 at 11:43:54AM +0100, Henrik Zagerholm wrote: > I'm having a hard time understanding why my query is not using my > indices when I change a field in the WHERE clause. The row count estimate for fk_filetype_id = 83 is high by an order of magnitude: > Bitmap Index Scan on tbl_file_idx6 (cost=0.00..25.65 rows=1251 > width=0) (actual time=21.958..21.958 rows=112 loops=1) > > Index Cond: (fk_filetype_id = 83) Have you run ANALYZE or VACUUM ANALYZE on these tables recently? If so then you might try increasing the statistics target for tbl_file.fk_filetype_id and perhaps some of the columns in the join conditions. -- Michael Fuhr
