X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 76498D1D9EE for ; Thu, 28 Aug 2003 14:22:02 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 22099-06 for ; Thu, 28 Aug 2003 11:21:28 -0300 (ADT) Received: from smtp.pspl.co.in (unknown [202.54.11.65]) by svr1.postgresql.org (Postfix) with ESMTP id C053AD1DA4D for ; Thu, 28 Aug 2003 11:21:14 -0300 (ADT) Received: (from root@localhost) by smtp.pspl.co.in (8.12.9/8.12.9) id h7SEPoLw005860 for ; Thu, 28 Aug 2003 19:55:50 +0530 Received: from daithan (daithan.intranet.pspl.co.in [192.168.7.161]) (authenticated bits=0) by persistent.co.in (8.12.9/8.12.9) with ESMTP id h7SEPnhi005832 for ; Thu, 28 Aug 2003 19:55:49 +0530 From: "Shridhar Daithankar" To: PgSQL Performance ML Date: Thu, 28 Aug 2003 19:53:13 +0530 MIME-Version: 1.0 Subject: Re: Hardware recommendations to scale to silly load Reply-To: shridhar_daithankar@persistent.co.in Message-ID: <3F4E5DA9.6396.5C8916@localhost> In-reply-to: <1062079515.88334.24.camel@morpheus> References: <1061953146.18108.291.camel@haggis> X-mailer: Pegasus Mail for Windows (v4.12a) Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Content-description: Mail message body X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/413 X-Sequence-Number: 3229 On 28 Aug 2003 at 11:05, Chris Bowlby wrote: > On Tue, 2003-08-26 at 23:59, Ron Johnson wrote: > > > What a fun exercises. Ok, lets see: > > Postgres 7.3.4 > > RH AS 2.1 > > 12GB RAM > > motherboard with 64 bit 66MHz PCI slots > > 4 - Xenon 3.0GHz (1MB cache) CPUs > > 8 - 36GB 15K RPM as RAID10 on a 64 bit 66MHz U320 controller > > having 512MB cache (for database) > > 2 - 36GB 15K RPM as RAID1 on a 64 bit 66MHz U320 controller > > having 512MB cache (for OS, swap, WAL files) > > 1 - library tape drive plugged into the OS' SCSI controller. I > > prefer DLT, but that's my DEC bias. > > 1 - 1000 volt UPS. > > Be careful here, we've seen that with the P4 Xeon's that are > hyper-threaded and a system that has very high disk I/O causes the > system to be sluggish and slow. But after disabling the hyper-threading > itself, our system flew.. Anybody has opteron working? Hows' the performance? Bye Shridhar -- A father doesn't destroy his children. -- Lt. Carolyn Palamas, "Who Mourns for Adonais?", stardate 3468.1.