Gavin Hamill <gdh@xxxxxxxxxxxxx> writes: > If I replace the > (allocation0_."Date" between '2006-06-09 00:00:00.000000' and > '2006-06-09 00:00:00.000000') > with > allocation0_."Date" ='2006-04-09 00:00:00.000000' > then the query comes back in a few milliseconds (as I'd expect :) Could we see EXPLAIN ANALYZE for * both forms of the date condition, with the roomid condition; * both forms of the date condition, WITHOUT the roomid condition; * just the roomid condition I'm thinking the planner is misestimating something, but it's hard to tell what without breaking it down. regards, tom lane
