Обсуждение: Select problems

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

On Thu, Aug 11, 2005 at 09:53:05PM +0200, Lucas Grijander wrote:
> 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.

Please post the output from "EXPLAIN ANALYZE SELECT ..." on both
systems so we can see what they're doing differently.

Are the hardware and postgresql.conf settings comparable?

--
Michael Fuhr