Select problems - Mailing list pgsql-novice

From Lucas Grijander
Subject Select problems
Date
Msg-id web-4142488@cgp6.sentechsa.net
Whole thread Raw
Responses Re: Select problems  (Michael Fuhr <mike@fuhr.org>)
List pgsql-novice
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.2 they both last for equal time.

I did a vacuum analyze with no success.

Please, could you help me?
Thanks in advance
_________________________________________________________________
Need software for your hardware? Click here http://www.asg.co.za

pgsql-novice by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Cast Problem
Next
From: Michael Fuhr
Date:
Subject: Re: Select problems