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 5CF1C3A4228 for ; Wed, 10 Nov 2004 17:06:26 +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 23863-10 for ; Wed, 10 Nov 2004 17:06:23 +0000 (GMT) Received: from tht.net (vista.tht.net [216.126.88.2]) by svr1.postgresql.org (Postfix) with ESMTP id 96ABF3A3C55 for ; Wed, 10 Nov 2004 17:06:22 +0000 (GMT) Received: from dyn-69-135.tor.dsl.tht.net (dyn-69-135.tor.dsl.tht.net [134.22.69.135]) by tht.net (Postfix) with ESMTP id CEF1B76B0C for ; Wed, 10 Nov 2004 12:06:19 -0500 (EST) Subject: Solaris 9 Tuning Tips requested From: Rod Taylor To: Postgresql Performance Content-Type: text/plain Date: Wed, 10 Nov 2004 12:04:12 -0500 Message-Id: <1100106252.79412.41.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/175 X-Sequence-Number: 9129 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. 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 or oddities in Disk IO or configuration settings as they related to Solaris (as they differ from an Intel). --