Re: analyzing postgresql performance for dbt-2

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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073