Re: analyzing postgresql performance for dbt-2 - Mailing list pgsql-performance

From Bruce Momjian
Subject Re: analyzing postgresql performance for dbt-2
Date
Msg-id 200310260436.h9Q4a9f09899@candle.pha.pa.us
Whole thread Raw
In response to Re: analyzing postgresql performance for dbt-2  (Mark Wong <markw@osdl.org>)
Responses Re: analyzing postgresql performance for dbt-2  (markw@osdl.org)
Re: analyzing postgresql performance for dbt-2  (markw@osdl.org)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: Performance Concern
Next
From: Yonatan Goraly
Date:
Subject: Slow performance with no apparent reason