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

From Mark Wong
Subject Re: [Testperf-general] Re: 8.0beta5 results w/ dbt2
Date
Msg-id 20041207081723.A8521@osdl.org
Whole thread Raw
In response to Re: [Testperf-general] Re: 8.0beta5 results w/ dbt2  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: [Testperf-general] Re: 8.0beta5 results w/ dbt2
List pgsql-hackers
On Tue, Dec 07, 2004 at 09:12:18AM +0000, Simon Riggs wrote:
> Not sure, as yet, what is causing effect 2. It's not related to the
> kernel, but is related to user CPU and I/O waits and effects all tables
> in proportion to their overall I/O usage. Some evidence that it becomes
> more pronounced as CPU utilisation peaks, possibly increasing slightly
> in frequency once this occurs: maybe the cache filling?

I never vacuum during the test.  Is it possible that all the updates
and inserts would affect this?

Mark


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Call for port reports
Next
From: Matthias Schmidt
Date:
Subject: Re: somebody working on: Prevent default re-use of sysids for dropped users and groups?