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 mi
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.
With PostgreSQL 7