Re: Slow query - possible bug?

Gavin Hamill <gdh@laterooms.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