X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.192]) by svr1.postgresql.org (Postfix) with ESMTP id 3F8FBD1C4E1 for ; Mon, 21 Jul 2003 18:06:06 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr4.postgresql.org [64.117.224.192]) (amavisd-new, port 10024) with ESMTP id 20952-04 for ; Mon, 21 Jul 2003 18:06:04 +0000 (GMT) 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 02398D1C914 for ; Mon, 21 Jul 2003 15:06:01 -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 h6LI75q04991 for ; Mon, 21 Jul 2003 15:07:06 -0300 Received: from 192.168.1.100 (SquirrelMail authenticated user alepaes) by webmail.ad2.com.br with HTTP; Mon, 21 Jul 2003 15:07:06 -0300 (BRT) Message-ID: <1330.192.168.1.100.1058810826.squirrel@webmail.ad2.com.br> In-Reply-To: <00b901c34f49$1ed04b40$0403a8c0@fejleszt4> References: <20030712112515.15711.h022.c001.wm@mail.dilger.cc.criticalpath.net> <00b901c34f49$1ed04b40$0403a8c0@fejleszt4> Date: Mon, 21 Jul 2003 15:07:06 -0300 (BRT) Subject: Re: Dual Xeon + HW RAID question From: "alexandre 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-Archive-Number: 200307/337 X-Sequence-Number: 2630 SZUCS, In my tests, I donīt a great performance enhacement with HT. I suspect that my problem resides on I/O performance. I will wait for a best moment to resinstall the system with other disk configurations and then I will report here. Thanks for all replys! Alexandre > Alexandre, > > I missed your orig. post, but AFAIK multiprocessing kernels will handle HT > CPUs as 2 CPUs each. Thus, our dual Xeon 2.4 is recognized as 4 Xeon 2.4 > CPUs. > > This way, I don't think HT would improve any single query (afaik no > postgres > process uses more than one cpu), but overall multi-query performance has > to > improve. > > ----- Original Message ----- > From: "Nikolaus Dilger" > Sent: Saturday, July 12, 2003 8:25 PM > > > Alexandre, > > Since you want the fastest speed I would do the 2 data > disks in RAID 0 (striping) not RAID 1 (mirroring). > > If you would care about not loosing any transactions > you would keep all 3 disks in RAID 5. > > Don't know the answer to the Hyperthreading question. > Why don't you run a test to find out? > > Regards, > Nikolaus > > On Thu, 10 Jul 2003 14:43:25 -0300 (BRT), "alexandre > arruda paes :: aldeia digital" wrote: > >> >> 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 > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org >