From: | "Bryan White" <bryan(at)arcamax(dot)com> |
---|---|
To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | "pgsql-general" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: PG 7.0 is 2.5 times slower running a big report |
Date: | 2000-05-25 02:57:14 |
Message-ID: | 004101bfc5f4$eead7360$0200a8c0@nwptn1.va.home.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> "Bryan White" <bryan(at)arcamax(dot)com> writes:
> >> What does EXPLAIN tell you about how the queries are being executed?
> >> Do you by any chance have the 6.5.3 system still available to compare
> >> its EXPLAIN output?
>
> > I can shuffle directories and reload under 6.5.3 but I need to wait
until
> > todays run of the report finishes. I got bit by the change in the
default
> > date format and had to run it again. As it is I won't be able to do
this
> > until the morning.
>
> Don't worry about it. Now that I've seen the queries, I know that there
> is only one query plan 6.5.3 could have used: seq-scan and sort. So
> there's no need to reload 6.5.3 just to see its EXPLAIN output.
I have set index_scan off for tomorrow morning's run. I will let you know
what happens.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2000-05-25 02:58:26 | Re: Postgres Instability |
Previous Message | Bryan White | 2000-05-25 02:45:36 | Re: PG 7.0 is 2.5 times slower running a big report |