From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Mark Wong <markw@osdl.org>
Cc: pgsql-performance@postgresql.org
Cc: osdldbt-general@lists.sourceforge.net
Subject: Re: analyzing postgresql performance for dbt-2
Date: Sun, 26 Oct 2003 00:36:09 -0400 (EDT)
Message-ID: <200310260436.h9Q4a9f09899@candle.pha.pa.us> (raw)
In-Reply-To: <20031021191033.A5484@osdlab.pdx.osdl.net>
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 most of the
> > > interactions also increases significantly:
> > >
> > > http://developer.osdl.org/markw/dbt2-pgsql/158/ [baseline]
> > > - load of 100 warehouses
> > > - metric 1249.65
> > >
> > > http://developer.osdl.org/markw/dbt2-pgsql/149/
> > > - load of 140 warehouses
> > > - metric 1323.90
> >
> > I looked at these charts and they looked normal to me. It looked like
> > your the load increased until your computer was saturated. Is there
> > something I am missing?
>
> I've run some i/o tests so I'm pretty sure I haven't saturated that. And it
> looks like I have almost 10% more processor time left. I do agree that it
> appears something might be saturated, I just don't know where to look...
Could the 10% be context switching time, or is the I/O saturated?
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: pgman@candle.pha.pa.us, markw@osdl.org, osdldbt-general@lists.sourceforge.net
Subject: Re: analyzing postgresql performance for dbt-2
In-Reply-To: <200310260436.h9Q4a9f09899@candle.pha.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox