pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedSelect problems
2+ messages / 2 participants
[nested] [flat]
* Select problems
@ 2005-08-11 11:44 Lucas Grijander <indibil@webmail.co.za>
2005-08-15 07:25 ` Re: Select problems Richard Huxton <dev@archonet.com>
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-11 11:44 Select problems Lucas Grijander <indibil@webmail.co.za>
@ 2005-08-15 07:25 ` Richard Huxton <dev@archonet.com>
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