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 570478B9E0F for ; Tue, 8 Feb 2005 02:23:46 +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 32897-01 for ; Tue, 8 Feb 2005 02:23:19 +0000 (GMT) Received: from davinci.ethosmedia.com (server227.ethosmedia.com [209.128.84.227]) by svr1.postgresql.org (Postfix) with ESMTP id BE3388B9E28 for ; Tue, 8 Feb 2005 02:23:21 +0000 (GMT) X-EthosMedia-Virus-Scanned: no infections found Received: from [63.195.55.98] (account josh@agliodbs.com HELO spooky) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.1.8) with ESMTP id 7001057; Mon, 07 Feb 2005 18:25:06 -0800 From: Josh Berkus Organization: Aglio Database Solutions To: paul@oxton.com Subject: Re: Solaris 9 tuning Date: Mon, 7 Feb 2005 18:22:42 -0800 User-Agent: KMail/1.6.2 Cc: pgsql-performance@postgresql.org References: <3834.81.134.31.64.1107815117.squirrel@www.gradwell.com> In-Reply-To: <3834.81.134.31.64.1107815117.squirrel@www.gradwell.com> MIME-Version: 1.0 Content-Disposition: inline Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Message-Id: <200502071822.42805.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.013 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200502/122 X-Sequence-Number: 10451 Paul, > I would like to know what /etc/system and postgresql_conf values are > recommended to deliver as much system resource as possible to Postgres. We > use this Sun box solely for single user Postgres data warehousing > workloads. What's your disk system? > shared_buffers = 500000 This is highly unlikely to be optimal. That's 3GB. On test linux systems up to 8GB, we've not seen useful values of shared buffers anywhere above 400mb. How did you arrive at that figure? > sort_mem = 2097152 > vacuum_mem = 1000000 These could be fine on a single-user system. sort_mem is per *sort* though, not per query, so you'd need to watch out for complex queries spillling into swap; perhaps set it a 0.5GB or 1GB? Otherwise, start with the config guide at www.powerpostgresql.com/PerfList -- Josh Berkus Aglio Database Solutions San Francisco