X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 6FE28D1B501 for ; Wed, 22 Oct 2003 02:11:10 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 95851-05 for ; Tue, 21 Oct 2003 23:10:43 -0300 (ADT) Received: from mail.osdl.org (fw.osdl.org [65.172.181.6]) by svr1.postgresql.org (Postfix) with ESMTP id 73AB5D1B4E9 for ; Tue, 21 Oct 2003 23:10:39 -0300 (ADT) Received: (from markw@localhost) by mail.osdl.org (8.11.6/8.11.6) id h9M2AXD06282; Tue, 21 Oct 2003 19:10:33 -0700 Date: Tue, 21 Oct 2003 19:10:33 -0700 From: Mark Wong To: Bruce Momjian Cc: pgsql-performance@postgresql.org, osdldbt-general@lists.sourceforge.net Subject: Re: analyzing postgresql performance for dbt-2 Message-ID: <20031021191033.A5484@osdlab.pdx.osdl.net> References: <200310220024.h9M0O5o19190@mail.osdl.org> <200310220035.h9M0Zul27091@candle.pha.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <200310220035.h9M0Zul27091@candle.pha.pa.us>; from pgman@candle.pha.pa.us on Tue, Oct 21, 2003 at 08:35:56PM -0400 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/565 X-Sequence-Number: 4313 On Tue, Oct 21, 2003 at 08:35:56PM -0400, Bruce Momjian wrote: > markw@osdl.org 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 performance drops. > > Nothing in the graphs (in the links listed later) sticks out to me so > > I'm wondering if there are other database statitics I should try to > > collect. Any suggestions would be great and let me know if I can answer > > any other questions. > > > > 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... Thanks, Mark