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

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:15:38
Message-ID: 001d01bfc5ef$1f62fda0$0200a8c0@nwptn1.va.home.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2000-05-25 02:23:51 Re: PG 7.0 is 2.5 times slower running a big report
Previous Message Lamar Owen 2000-05-25 02:14:37 Re: Postgres Instability