Re: performance problem aftrer update from 7.1 to 7.4.2 - Mailing list pgsql-general

From Tom Lane
Subject Re: performance problem aftrer update from 7.1 to 7.4.2
Date
Msg-id 20216.1082611062@sss.pgh.pa.us
Whole thread Raw
In response to Re: performance problem aftrer update from 7.1 to 7.4.2  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Responses Re: performance problem aftrer update from 7.1 to 7.4.2
List pgsql-general
Stephan Szabo <sszabo@megazone.bigpanda.com> writes:
> On Thu, 22 Apr 2004, Development - multi.art.studio wrote:
>> so in 7.4 seq-scan is about '1'  (ms or what?) slower than 7.1

> The cost numbers from explain have no direct connection to real time.

... or at least, if your concern is poor choice of query plan, it's
folly to treat them as being equivalent to real time.  Actual runtimes
are the things to compare.

Also, I wouldn't care to bet that estimated costs from 7.1 are very
comparable to 7.4, anyway.  We rejiggered the cost models enough in
between that it's quite likely to be a meaningless comparison.

            regards, tom lane

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [OT] Tom's/Marc's spam filters?
Next
From: Peter Eisentraut
Date:
Subject: Re: Installation - SuSE 9.0