X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 8B9DA3A4235 for ; Wed, 10 Nov 2004 16:54:47 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 19799-09 for ; Wed, 10 Nov 2004 16:54:42 +0000 (GMT) Received: from server2.sitesell.com (server2.sitesell.com [216.95.221.3]) by svr1.postgresql.org (Postfix) with SMTP id 083993A4222 for ; Wed, 10 Nov 2004 16:54:41 +0000 (GMT) Received: (qmail 27769 invoked from network); 10 Nov 2004 16:54:39 -0000 Received: from dyn-69-135.tor.dsl.tht.net (134.22.69.135) by server2.sitesell.com with SMTP; 10 Nov 2004 16:54:39 -0000 Subject: Tuning suggestions wanted From: Rod Taylor To: Postgresql Performance Content-Type: text/plain Date: Wed, 10 Nov 2004 11:52:34 -0500 Message-Id: <1100105554.79412.37.camel@home> Mime-Version: 1.0 X-Mailer: Evolution 2.0.2 FreeBSD GNOME Team Port Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/207 X-Sequence-Number: 9161 I'm looking for suggestions on tuning Solaris 9 for a SunFire 890 (Ultra IV chips) connected to an Hitachi 9500V running PostgreSQL 7.4. So that I don't lead people in a direction, I'll hold off for a while before posting our configuration settings. Database is approx 160GB in size with a churn of around 4GB per day (2 GB updated, 2GB inserted, very little removed). It's a mixture of OLTP and reporting. 5% is reports which do trickle writes 95% is short (30 second or less) transactions with about 10 selects, 10 writes (inserts, updates, deletes all mixed in) affecting 150 tuples. Thanks for any tips -- particularly Solaris kernel tuning. -- Rod Taylor