I've done a better controlled series of tests where I restore the
database before each test and have grabbed sar and oprofile data:
http://developer.osdl.org/markw/dbt2-pgsql/176/
- load of 100 warehouses
- metric 1234.52
http://developer.osdl.org/markw/dbt2-pgsql/177/
- l
On 26 Oct, Bruce Momjian wrote:
> Mark Wong wrote:
>> > > Here are a pair of results where I just raise the load on the
>> > > database, where increasing the load increases the area of the database
>> > > touched in addition to increasing the transaction rate. The overall
>> > > metric increases s
Mark Wong wrote:
> > > Here are a pair of results where I just raise the load on the
> > > database, where increasing the load increases the area of the database
> > > touched in addition to increasing the transaction rate. The overall
> > > metric increases somewhat, but the response time for mos
On Tue, Oct 21, 2003 at 08:35:56PM -0400, Bruce Momjian wrote:
> [EMAIL PROTECTED] wrote:
> > I'm running our DBT-2 workload against PostgreSQL 7.3.4 and I'm having
> > some trouble figuring out what I should be looking for when I'm trying
> > to tune the database. I have results for a decent base
[EMAIL PROTECTED] wrote:
> I'm running our DBT-2 workload against PostgreSQL 7.3.4 and I'm having
> some trouble figuring out what I should be looking for when I'm trying
> to tune the database. I have results for a decent baseline, but when I
> try to increase the load on the database, the perfor
I'm running our DBT-2 workload against PostgreSQL 7.3.4 and I'm having
some trouble figuring out what I should be looking for when I'm trying
to tune the database. I have results for a decent baseline, but when I
try to increase the load on the database, the performance drops.
Nothing in the graph