X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id 70B2DCB77B for ; Fri, 11 Jul 2003 00:41:43 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 16103-07 for ; Thu, 10 Jul 2003 21:41:28 -0300 (ADT) Received: from spirit.aldeiadigital.com.br (iplus-fac-225-213-137.xdsl-fixo.ctbcnetsuper.com.br [200.225.213.137]) by svr1.postgresql.org (Postfix) with ESMTP id 3330ACC570 for ; Thu, 10 Jul 2003 14:41:53 -0300 (ADT) Received: from webmail.ad2.com.br (localhost.localdomain [127.0.0.1]) by spirit.aldeiadigital.com.br (8.11.6/8.11.6) with SMTP id h6AHhMY25122 for ; Thu, 10 Jul 2003 14:43:25 -0300 Received: from 192.168.1.100 (SquirrelMail authenticated user alepaes) by webmail.ad2.com.br with HTTP; Thu, 10 Jul 2003 14:43:25 -0300 (BRT) Message-ID: <1192.192.168.1.100.1057859005.squirrel@webmail.ad2.com.br> Date: Thu, 10 Jul 2003 14:43:25 -0300 (BRT) Subject: Dual Xeon + HW RAID question From: "alexandre arruda paes :: aldeia digital" To: pgsql-performance@postgresql.org User-Agent: SquirrelMail/1.4.0 MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 X-Priority: 3 Importance: Normal X-Virus-Scanned: by amavisd-milter (http://amavis.org/) X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.5 tagged_above=0.0 required=5.0 tests=PRIORITY_NO_NAME, USER_AGENT X-Spam-Level: * X-Archive-Number: 200307/168 X-Sequence-Number: 2461 Hi, I have this machine with a 10 million records: * Dual Xeon 2.0 (HyperThreading enabled), 3 7200 SCSI , Adaptec 2110S, RAID 5 - 32k chunk size, 1 GB Ram DDR 266 ECC, RH 8.0 - 2.4.18 The database is mirrored with contrib/dbmirror in a P4 1 Gb Ram + IDE If a disk failure occurs, I can use the server in the mirror. I will format the main server in this weekend and I have seen in the list some people that recomends a Software RAID instead HW. I think too remove the RAID 5 and turn a RAID 1 for data in 2 HDs. SO, WAL and swap in the thrid HD. My questions: 1) I will see best disk performance changing the disk layout like above 2) HyperThreading really improve a procces basead program, like postgres Thank´s for all Alexandre