X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B52CFD957E for ; Mon, 21 Nov 2005 05:34:41 -0400 (AST) 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 91864-02 for ; Mon, 21 Nov 2005 09:34:42 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from svr2.postgresql.org (svr2.postgresql.org [65.19.161.25]) by svr1.postgresql.org (Postfix) with ESMTP id 3D22AD92BC for ; Mon, 21 Nov 2005 05:34:39 -0400 (AST) Received: from pjetlic.mobart.hr (pjetlic.mobart.hr [80.80.51.10]) by svr2.postgresql.org (Postfix) with ESMTP id 15D38F0B05 for ; Mon, 21 Nov 2005 09:34:40 +0000 (GMT) Received: from localhost (localhost.localdomain [127.0.0.1]) by pjetlic.mobart.hr (Postfix) with ESMTP id 007A017A13; Mon, 21 Nov 2005 10:34:36 +0100 (CET) Received: from pjetlic.mobart.hr ([127.0.0.1]) by localhost (pjetlic [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 14484-01-14; Mon, 21 Nov 2005 10:34:36 +0100 (CET) Received: from mike.mobart.hr (mike.mobart.hr [192.168.10.94]) (using SSLv3 with cipher RC4-MD5 (128/128 bits)) (No client certificate requested) by pjetlic.mobart.hr (Postfix) with ESMTP id D6E4512BC3; Mon, 21 Nov 2005 10:34:36 +0100 (CET) Subject: Re: Server Hardware Configuration From: Mario Splivalo Reply-To: mario.splivalo@mobart.hr To: "Jim C. Nasby" Cc: pgsql-admin@postgresql.org In-Reply-To: <20051120175337.GP19279@pervasive.com> References: <20051120175337.GP19279@pervasive.com> Content-Type: text/plain Organization: Mob-Art Date: Mon, 21 Nov 2005 10:34:36 +0100 Message-Id: <1132565676.8689.9.camel@ekim> Mime-Version: 1.0 X-Mailer: Evolution 2.4.1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by OpenSource AV+AS Mail Server X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200511/271 X-Sequence-Number: 19644 On Sun, 2005-11-20 at 11:53 -0600, Jim C. Nasby wrote: > Two general comments: most people find that Opterons perform much better > than Xeons. With some versions of PostgreSQL, the difference is over > 50%. Could you be more specific on that? Which version of Postgres perform better on Opteron than on Xeon? > RAID5 generally doesn't make for a fast database. The problem is that > there is a huge amount of overhead everytime you go to write something > out to a RAID5 array. With careful tuning of the background writer you > might be able to avoid some of that penalty, though your read > performance will likely still be affected by the write overhead. RAID5 was not ment to improve performance, but to minimize disaster and downtime when your hard disk dies. We're using RAID5 with postgres. In the last 3 years we changed 5 disks, but the system downtime was zero minutes. Mike -- Mario Splivalo Mob-Art mario.splivalo@mobart.hr "I can do it quick, I can do it cheap, I can do it well. Pick any two."