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 57B5B5640D for ; Wed, 9 Mar 2005 03:07:48 +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 98841-07 for ; Wed, 9 Mar 2005 03:07:44 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.194]) by svr1.postgresql.org (Postfix) with ESMTP id 990D556386 for ; Wed, 9 Mar 2005 03:07:43 +0000 (GMT) Received: by wproxy.gmail.com with SMTP id 70so39033wra for ; Tue, 08 Mar 2005 19:07:48 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type:content-transfer-encoding; b=uLnU2TTCfWe9Z9PVk7ymJBSwZgqv06I/qqgidTSw2niF5xjdB7/54xeA9Mj3/naww18qCkZu1klH4cA3fDq2YeQemmaK5QIGPNWryWs/D7m23EAN5l1VuUKj02MEY56XFBvm45FYZduwwLYyeDYNrgl1q2kwkHfqBL66/RqTwoY= Received: by 10.54.71.17 with SMTP id t17mr346121wra; Tue, 08 Mar 2005 19:07:48 -0800 (PST) Received: by 10.54.40.28 with HTTP; Tue, 8 Mar 2005 19:07:48 -0800 (PST) Message-ID: Date: Tue, 8 Mar 2005 19:07:48 -0800 From: David B Reply-To: David B To: pgsql-performance@postgresql.org Subject: 64bit Opteron multi drive raid. Help with best config settings Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.914 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, FROM_ENDS_IN_NUMS, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200503/152 X-Sequence-Number: 10857 Hi folks, I'm about to start testing PGv8 on an Opteron 64bit box with 12GB Ram running RedHat. A bunch of raided drives in the backend. Expecting 50GB of data per month (100GB+ initial load). I do not see any example config settings. Have some MySql experience and and for it there are config settings for small or large server operations. Does PG have similar examples (if so they are well hidden=E2=80=A6at least from Google search). If not can any of you send me a typical config for such an environment. I basically want to get a good setting so I can good insert performance=E2=80=A6low vol selects. DB data consists of customer info and their call history. Lots of customers=E2=80=A6lots of call history. Not that wide of rows. Want to be able to insert at rate of 1000's per sec. Should think thats pos= s. Any help you folks can provide to optimize this in a shootout between it and MSql (we hope to be move from Oracle) Tx, David