Re: PG 7.0 is 2.5 times slower running a big report

"Bryan White" <bryan@arcamax.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.

            regards, tom lane