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 66FA9D9632 for ; Mon, 21 Nov 2005 06:23:52 -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 97342-01 for ; Mon, 21 Nov 2005 10:23:53 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from pjetlic.mobart.hr (pjetlic.mobart.hr [80.80.51.10]) by svr1.postgresql.org (Postfix) with ESMTP id 90F3ED9771 for ; Mon, 21 Nov 2005 06:23:49 -0400 (AST) Received: from localhost (localhost.localdomain [127.0.0.1]) by pjetlic.mobart.hr (Postfix) with ESMTP id 7BC5C17A13; Mon, 21 Nov 2005 11:23:51 +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 17420-01-7; Mon, 21 Nov 2005 11:23:51 +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 6164C17A11; Mon, 21 Nov 2005 11:23:51 +0100 (CET) Subject: Re: Server Hardware Configuration From: Mario Splivalo Reply-To: mario.splivalo@mobart.hr To: Marcin Giedz Cc: pgsql-admin@postgresql.org In-Reply-To: <200511211058.41632.marcin.giedz@eulerhermes.pl> References: <20051120175337.GP19279@pervasive.com> <1132565676.8689.9.camel@ekim> <200511211058.41632.marcin.giedz@eulerhermes.pl> Content-Type: text/plain; charset=UTF-8 Organization: Mob-Art Date: Mon, 21 Nov 2005 11:23:51 +0100 Message-Id: <1132568631.8689.24.camel@ekim> Mime-Version: 1.0 X-Mailer: Evolution 2.4.1 Content-Transfer-Encoding: 8bit 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/275 X-Sequence-Number: 19648 On Mon, 2005-11-21 at 10:58 +0100, Marcin Giedz wrote: > Dnia poniedziaƂek, 21 listopada 2005 10:34, Mario Splivalo napisaƂ: > > 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? > > Try http://85.128.68.44 - I made some test about Xeon and Opteron Cool! :) Could you give specs on processors itself? The clock, cache, and stuff? > > 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. > > I'm ready enough to put some tests about different RAID's for Postgresql - but > I will soon. However almost all people I know preffer RAID10 for database > like PGSQL. What do you mean when you say RAID10? Raid 1+0, or striped raid 5? 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."