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 409F35336F for ; Mon, 28 Mar 2005 16:44:55 +0100 (BST) 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 82979-10 for ; Mon, 28 Mar 2005 15:44:46 +0000 (GMT) Received: from window.monsterlabs.com (window.monsterlabs.com [216.183.105.176]) by svr1.postgresql.org (Postfix) with SMTP id 18BF453376 for ; Mon, 28 Mar 2005 16:44:45 +0100 (BST) Received: (qmail 26641 invoked from network); 28 Mar 2005 15:44:50 -0000 Received: from host-209.149.56.238.nashville.net (HELO ?10.0.1.2?) (209.149.56.238) by 0 with SMTP; 28 Mar 2005 15:44:50 -0000 In-Reply-To: References: Mime-Version: 1.0 (Apple Message framework v619.2) Content-Type: text/plain; charset=WINDOWS-1252; delsp=yes; format=flowed Message-Id: <85e32fe05043b0bc0e94258bd9160024@sitening.com> Content-Transfer-Encoding: quoted-printable Cc: pgsql-performance@postgresql.org From: Thomas F.O'Connell Subject: Re: Configuration/Tuning of server/DB Date: Mon, 28 Mar 2005 09:44:49 -0600 To: Reid Thompson X-Mailer: Apple Mail (2.619.2) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200503/602 X-Sequence-Number: 11307 Reid, There are a few very valuable tuning documents that are part of the =20 established PostgreSQL-related literature. You don't mention which =20 version of postgres you'll be running, but here are the documents =20 you'll find useful: postgresql.conf 7.4: =20 http://www.varlena.com/varlena/GeneralBits/Tidbits/=20 annotated_conf_e.html 8.0: http://www.powerpostgresql.com/Downloads/annotated_conf_80.html general tuning http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html -tfo -- Thomas F. O'Connell Co-Founder, Information Architect Sitening, LLC Strategic Open Source =97 Open Your i=99 http://www.sitening.com/ 110 30th Avenue North, Suite 6 Nashville, TN 37203-6320 615-260-0005 On Mar 24, 2005, at 1:46 PM, Reid Thompson wrote: > Using information found on the web, I've come up with some =20 > configuration and tuning parameters for a server/db that we will be =20= > implementing. I was wondering if I could generate some feedback as to = =20 > configuration and tuning so that I could compare my estimations with =20= > those of others. > > Host is AIX 5.1 with 4 cpu's and 4 GB ram. Postgresql will be sharing = =20 > this machine with other processes. Storage is an EMC storage array. =20= > The DB itself is very simple. Two tables, one with 40-45 columns ( =20= > largest column will likely contain no more than 32 chars of data ), =20= > the other with less than 5 columns ( largest column will contain no =20= > more than 20 chars data ). Expected transactions will be along the =20= > order of ~600K +- 100K inserts and ~600K +-200K updates per week. > > Thanks > > ---------------------------(end of =20 > broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to =20 > majordomo@postgresql.org