Gavin Hamill <gdh(at)laterooms(dot)com> 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