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 445C8329EAE for ; Wed, 15 Sep 2004 20:14:09 +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 65176-03 for ; Wed, 15 Sep 2004 19:14:03 +0000 (GMT) Received: from mproxy.gmail.com (rproxy.gmail.com [64.233.170.193]) by svr1.postgresql.org (Postfix) with ESMTP id E66E3329E77 for ; Wed, 15 Sep 2004 20:14:03 +0100 (BST) Received: by mproxy.gmail.com with SMTP id 74so109627rnl for ; Wed, 15 Sep 2004 12:13:54 -0700 (PDT) Received: by 10.38.125.25 with SMTP id x25mr738436rnc; Wed, 15 Sep 2004 12:13:54 -0700 (PDT) Received: by 10.38.208.23 with HTTP; Wed, 15 Sep 2004 12:13:54 -0700 (PDT) Message-ID: <96624965040915121338c85981@mail.gmail.com> Date: Wed, 15 Sep 2004 12:13:54 -0700 From: Marc Slemko Reply-To: Marc Slemko To: "Jeffrey W. Baker" Subject: Re: disk performance benchmarks Cc: pgsql-general@postgresql.org In-Reply-To: <1095264696.8243.0.camel@localhost.localdomain> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit References: <1095185498.5792.12.camel@localhost.localdomain> <003801c49b07$f33b6990$ad01a8c0@zaphod> <1095264696.8243.0.camel@localhost.localdomain> 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/731 X-Sequence-Number: 65937 On Wed, 15 Sep 2004 09:11:37 -0700, Jeffrey W. Baker wrote: > 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". Umh, I don't think you have shown any numbers to show if the database is using the capacity of the hardware or not... If this is a seek heavy operation, the raw throughput is irrelevant; you are limited by the number of seeks your disks can do. Run some iostats and look at the number of transactions per second. Using raid 5 can just destroy the number of write transactions per second you can do, especially if it is software raid or a cheap raid controller. You can't just say "the hardware is fine and not stressed so I don't want to discuss that, but everything is too slow so please make it faster".