Re: [Testperf-general] Re: 8.0beta5 results w/ dbt2 - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [Testperf-general] Re: 8.0beta5 results w/ dbt2
Date
Msg-id 25330.1102831993@sss.pgh.pa.us
Whole thread Raw
In response to Re: [Testperf-general] Re: 8.0beta5 results w/ dbt2  (Mark Wong <markw@osdl.org>)
Responses Re: [Testperf-general] Re: 8.0beta5 results w/ dbt2
List pgsql-hackers
Mark Wong <markw@osdl.org> writes:
> I never vacuum during the test.  Is it possible that all the updates
> and inserts would affect this?

That's bad; first because it possibly *is* hurting performance, and
second because if it isn't, your results could legitimately be attacked
as not representing the long-term-sustainable performance of Postgres.
VACUUM is real, unavoidable overhead and so we have to account for it
honestly.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Neil Conway
Date:
Subject: Re: [Testperf-general] BufferSync and bgwriter
Next
From: Tom Lane
Date:
Subject: Re: [GENERAL] replacing a view: bug or feature?