X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id CBBFB329E3D for ; Wed, 15 Sep 2004 17:12:28 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 95104-07 for ; Wed, 15 Sep 2004 16:12:22 +0000 (GMT) Received: from gghcwest.com (adsl-64-164-133-219.dsl.snfc21.pacbell.net [64.164.133.219]) by svr1.postgresql.org (Postfix) with ESMTP id DEA81329E01 for ; Wed, 15 Sep 2004 17:12:21 +0100 (BST) Received: from localhost.localdomain (toonses.gghcwest.com [192.168.168.115]) by gghcwest.com (8.12.10/8.12.9) with ESMTP id i8FGCJst032176 for ; Wed, 15 Sep 2004 09:12:19 -0700 Received: from jwb by localhost.localdomain with local (Exim 4.34) id 1C7cNd-00029Z-3H for pgsql-general@postgresql.org; Wed, 15 Sep 2004 09:11:37 -0700 Subject: Re: disk performance benchmarks From: "Jeffrey W. Baker" To: pgsql-general@postgresql.org In-Reply-To: <003801c49b07$f33b6990$ad01a8c0@zaphod> References: <1095185498.5792.12.camel@localhost.localdomain> <003801c49b07$f33b6990$ad01a8c0@zaphod> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1095264696.8243.0.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 Date: Wed, 15 Sep 2004 09:11:37 -0700 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200409/701 X-Sequence-Number: 65907 On Wed, 2004-09-15 at 02:39, Michael Paesold wrote: > Jeffrey W. Baker wrote: > > > Current issue: > > > > A dual 64-bit Opteron 244 machine with 8GB main memory, two 4-disk RAID5 > > arrays (one for database, one for xlogs). PG's config is extremely > > generous, and in isolated benchmarks it's very fast. > > It depends on the controller, but usually I would expect a better > performance if xlogs are just on a two-disk mirror and the rest of the disks > for data (6 splindles instead of 4 then). > > I don't think RAID5 is a benefit for xlogs. All these replies are really interesting, but the point is not that my RAIDs are too slow, or that my CPUs are too slow. My point is that, for long stretches of time, by database doesn't come anywhere near using the capacity of the hardware. And I think that's odd and would like to config it to "false". -jwb