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 8128A329E94 for ; Wed, 15 Sep 2004 10:40:01 +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 45170-06 for ; Wed, 15 Sep 2004 09:39:50 +0000 (GMT) Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by svr1.postgresql.org (Postfix) with SMTP id 02100329EBD for ; Wed, 15 Sep 2004 10:39:51 +0100 (BST) Received: (qmail 13088 invoked by uid 65534); 15 Sep 2004 09:39:51 -0000 Received: from office01.emerion.com (EHLO zaphod) (83.64.50.26) by mail.gmx.net (mp026) with SMTP; 15 Sep 2004 11:39:51 +0200 X-Authenticated: #1946847 Message-ID: <003801c49b07$f33b6990$ad01a8c0@zaphod> From: "Michael Paesold" To: "Jeffrey W. Baker" Cc: References: <1095185498.5792.12.camel@localhost.localdomain> Subject: Re: disk performance benchmarks Date: Wed, 15 Sep 2004 11:39:42 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 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/681 X-Sequence-Number: 65887 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. Regards, Michael Paesold > But, in reality, performance is abyssmal. There's something about what > PG does inside commits and checkpoints that sends Linux into a catatonic > state. For instance here's a snapshot of vmstat during a parallel heavy > select/insert load: ...