pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

Select problems
2+ messages / 2 participants
[nested] [flat]

* Select problems
@ 2005-08-11 11:44  Lucas Grijander <indibil@webmail.co.za>
  0 siblings, 1 reply; 2+ messages in thread

From: Lucas Grijander @ 2005-08-11 11:44 UTC (permalink / raw)
  To: 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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Select problems
@ 2005-08-15 07:25  Richard Huxton <dev@archonet.com>
  parent: Lucas Grijander <indibil@webmail.co.za>
  0 siblings, 0 replies; 2+ messages in thread

From: Richard Huxton @ 2005-08-15 07:25 UTC (permalink / raw)
  To: Lucas Grijander <indibil@webmail.co.za>; +Cc: pgsql-sql

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 minutes.

And what are teh view definitions and the output of EXPLAIN ANALYSE?

-- 
   Richard Huxton
   Archonet Ltd



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2005-08-15 07:25 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-08-11 11:44 Select problems Lucas Grijander <indibil@webmail.co.za>
2005-08-15 07:25 ` Richard Huxton <dev@archonet.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox