Postgres Pro
Downloads
Home   >   mailing lists

Select problems - Mailing list pgsql-sql

From Lucas Grijander
Subject Select problems
Date
Msg-id web-3595244@cgp7.sentechsa.net
Whole thread Raw
Responses Re: Select problems  (Richard Huxton <dev@archonet.com>)
List pgsql-sql
Tree view 
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-sql by date:

Previous
From: "Akshay Mathur"
Date:
Subject: sql function: using set as argument
Next
From: dario.mx@gmail.com
Date:
Subject: Parentheses in FROM clause and evaluation order.