| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | Lucas Grijander <indibil(at)webmail(dot)co(dot)za> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Select problems |
| Date: | 2005-08-11 20:04:45 |
| Message-ID: | 20050811200445.GA94599@winnie.fuhr.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | operationsengineer1 | 2005-08-11 21:14:03 | Re: Cast Problem |
| Previous Message | Lucas Grijander | 2005-08-11 19:53:05 | Select problems |