Lucas Grijander wrote:
> Hi:
>
> I've just migrated from Linux/PostgreSQL 7.2 to
> Windows/PostgreSQL 8.0.3. I have a large view. When I make:
>
> "Select ..... WHERE mydate = 'anydate'"
> the view lasts 19 seconds to complete. But, when I make:
> "Select ..... WHERE mydate >= 'anydate'"
> the view lasts 7 minutes.
And what are teh view definitions and the output of EXPLAIN ANALYSE?
--
Richard Huxton
Archonet Ltd