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 7FC8AD983C for ; Mon, 21 Nov 2005 06:36:49 -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 95084-08 for ; Mon, 21 Nov 2005 10:36:48 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.eulerhermes.pl (host-ip43-68.crowley.pl [85.128.68.43]) by svr1.postgresql.org (Postfix) with ESMTP id E5D5CD977D for ; Mon, 21 Nov 2005 06:36:43 -0400 (AST) Received: from [192.168.49.9] (helo=xterm.podsiec) by mail.eulerhermes.pl with esmtpa (Exim 4.42) id 1Ee92T-00028J-V2; Mon, 21 Nov 2005 11:36:45 +0100 From: Marcin Giedz Organization: Euler Hermes To: mario.splivalo@mobart.hr Subject: Re: Server Hardware Configuration Date: Mon, 21 Nov 2005 11:36:42 +0100 User-Agent: KMail/1.7.1 Cc: pgsql-admin@postgresql.org References: <200511211058.41632.marcin.giedz@eulerhermes.pl> <1132568631.8689.24.camel@ekim> In-Reply-To: <1132568631.8689.24.camel@ekim> MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200511211136.42214.marcin.giedz@eulerhermes.pl> 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/276 X-Sequence-Number: 19649 Dnia poniedzia=C5=82ek, 21 listopada 2005 11:23, Mario Splivalo napisa=C5= =82: > On Mon, 2005-11-21 at 10:58 +0100, Marcin Giedz wrote: > > Dnia poniedzia=C5=82ek, 21 listopada 2005 10:34, Mario Splivalo napisa= =C5=82: > > > 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? Look at this site once again - made some additional info. > > > > RAID5 was not ment to improve performance, but to minimize disaster a= nd > > > 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? Raid 1+0. > > Mike