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 1AB1FD1C4B8 for ; Wed, 13 Aug 2003 14:44:17 +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 27804-05 for ; Wed, 13 Aug 2003 11:42:44 -0300 (ADT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 6CF83D1B56B for ; Wed, 13 Aug 2003 11:44:05 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h7DEbVSa023798; Wed, 13 Aug 2003 10:37:31 -0400 (EDT) To: Jeff Cc: Christopher Browne , "pgsql-performance@postgresql.org" Subject: Re: Perfomance Tuning In-reply-to: References: Comments: In-reply-to Jeff message dated "Wed, 13 Aug 2003 09:55:53 -0400" Date: Wed, 13 Aug 2003 10:37:31 -0400 Message-ID: <23797.1060785451@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/235 X-Sequence-Number: 3052 Jeff writes: > On Tue, 12 Aug 2003, Christopher Browne wrote: >> Are you _certain_ that's still true? Have you a metric that shows >> Informix being 10x faster on a modern system? That would be quite >> surprising... > We were forced (for budget reason) to switch from raw disk to cooked files > on our informix db. We took a huge hit - about 5-6x slower. > [snip] > The raw disks were on a hitachi fibre array and the cooked files > were on a raid5 (scsi). Forget how many spindles in the raid. > There were 20 raw disks) Seems like you can't know how much of the performance hit was due to the filesystem change and how much to the hardware change. But I'd bet 20 disks on fibre array have way more net throughput than a single RAID array on scsi. regards, tom lane