Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 4B6889FB5DB for ; Wed, 13 Jun 2007 13:45:03 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 91967-03 for ; Wed, 13 Jun 2007 13:44:43 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from nabagan.bluegap.ch (nabagan.bluegap.ch [88.198.58.248]) by postgresql.org (Postfix) with ESMTP id 150B59FB4B5 for ; Wed, 13 Jun 2007 13:44:49 -0300 (ADT) Received: from [192.168.0.232] (berlin.programmfabrik.de [::ffff:213.221.101.147]) (AUTH: CRAM-MD5 markus@bluegap.ch, TLS: TLSv1/SSLv3, 256bits, AES256-SHA) by nabagan.bluegap.ch with esmtp; Wed, 13 Jun 2007 19:37:49 +0200 id 00628D64.46702B6D.00000142 Message-ID: <46701EB7.8080208@bluegap.ch> Date: Wed, 13 Jun 2007 18:43:35 +0200 From: Markus Schiltknecht User-Agent: Icedove 1.5.0.10 (X11/20070329) MIME-Version: 1.0 To: Mark Wong CC: Heikki Linnakangas , Jim Nasby , PFC , pgsql-performance@postgresql.org Subject: Re: dbt2 NOTPM numbers References: <466428F7.5010808@bluegap.ch> <46642B33.6030101@enterprisedb.com> <46642F2E.3080509@bluegap.ch> <46646065.50806@bluegap.ch> <47BE2772-D774-4E2C-9D02-FD24C9F6BB90@decibel.org> <466D6A9E.4010703@bluegap.ch> <466D6B8A.6030509@enterprisedb.com> <466D6DD8.5060201@bluegap.ch> <70c01d1d0706130933p2a9a348coa4d3c3bbf607c65a@mail.gmail.com> In-Reply-To: <70c01d1d0706130933p2a9a348coa4d3c3bbf607c65a@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/241 X-Sequence-Number: 25274 Hi, Mark Wong wrote: > Yeah, I ran with 500+ warehouses, but I had 6 14-disk arrays of 15K > RPM scsi drives and 6 dual-channel controllers... :) Lucky you! In the mean time, I've figured out that the box in question peaked at about 1450 NOTPMs with 120 warehouses with RAID 1+0. I'll try to compare again to RAID 6. Is there any place where such results are collected? Regards Markus