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 7017E8B9E02 for ; Wed, 9 Feb 2005 19:03:03 +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 31360-08 for ; Wed, 9 Feb 2005 19:02:47 +0000 (GMT) Received: from yellow.gradwell.net (www.gradwell.com [193.111.200.100]) by svr1.postgresql.org (Postfix) with ESMTP id 17B8C8B9D5D for ; Wed, 9 Feb 2005 19:02:46 +0000 (GMT) Received: from www.gradwell.com (yellow.gradwell.net [127.0.0.1]) by yellow.gradwell.net (8.11.6/8.11.6) with SMTP id j19J2fl32296; Wed, 9 Feb 2005 19:02:42 GMT Received: from 80.5.160.4 (proxying for 213.106.154.123) (SquirrelMail authenticated user paul@pop3.oxton.com) by www.gradwell.com with HTTP; Wed, 9 Feb 2005 19:02:42 -0000 (GMT) Message-ID: <28097.80.5.160.4.1107975762.squirrel@www.gradwell.com> Date: Wed, 9 Feb 2005 19:02:42 -0000 (GMT) Subject: Re: Solaris 9 tuning From: "Paul Johnson" To: "Josh Berkus" Cc: pgsql-performance@postgresql.org Reply-To: paul@oxton.com User-Agent: SquirrelMail/1.4.2 MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 Importance: Normal References: <3834.81.134.31.64.1107815117.squirrel@www.gradwell.com> <200502071822.42805.josh@agliodbs.com> In-Reply-To: <200502071822.42805.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200502/145 X-Sequence-Number: 10474 Hi Josh, there are 8 internal disks - all are 18GB@10,000 RPM, fibre connected. The O/S is on 2 mirrored disks, the Postgres cluster is on the /data1 filesystem that is striped across the other 6 disks. The shared_buffers value is a semi-educated guess based on having made 4GB shared memory available via /etc/system, and having read all we could find on various web sites. Should I knock it down to 400MB as you suggest? I'll check out that URL. Cheers, Paul. > 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