Re: PG 7.0 is 2.5 times slower running a big report - Mailing list pgsql-general

From Bryan White
Subject Re: PG 7.0 is 2.5 times slower running a big report
Date
Msg-id 001d01bfc5ef$1f62fda0$0200a8c0@nwptn1.va.home.com
Whole thread Raw
In response to PG 7.0 is 2.5 times slower running a big report  ("Bryan White" <bryan@arcamax.com>)
Responses Re: PG 7.0 is 2.5 times slower running a big report  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
> 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.


pgsql-general by date:

Previous
From: "Bryan White"
Date:
Subject: Re: PG 7.0 is 2.5 times slower running a big report
Next
From: Tom Lane
Date:
Subject: Re: PG 7.0 is 2.5 times slower running a big report