Select problems

From: "Lucas Grijander" <indibil(at)webmail(dot)co(dot)za>
To: pgsql-sql(at)postgresql(dot)org
Subject: Select problems
Date: 2005-08-11 11:44:53
Message-ID: web-3595244@cgp7.sentechsa.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message nori 2005-08-11 12:17:26 Re: How to alias table columns in result?
Previous Message Nick Stone 2005-08-11 09:56:54 Re: How to alias table columns in result?