X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.225.181]) by svr1.postgresql.org (Postfix) with ESMTP id 68035CC4E3 for ; Thu, 17 Jul 2003 18:41:10 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr5.postgresql.org [64.117.225.181]) (amavisd-new, port 10024) with ESMTP id 91806-09 for ; Thu, 17 Jul 2003 18:41:29 +0000 (GMT) Received: from mail.libertyrms.com (unknown [209.167.124.227]) by svr1.postgresql.org (Postfix) with ESMTP id 3BA08CBB94 for ; Thu, 17 Jul 2003 15:40:59 -0300 (ADT) Received: from [10.1.2.130] (helo=dba2) by mail.libertyrms.com with esmtp (Exim 3.22 #3 (Debian)) id 19dDh3-0000JG-00 for ; Thu, 17 Jul 2003 14:41:29 -0400 Received: by dba2 (Postfix, from userid 1019) id 173A5CEC9; Thu, 17 Jul 2003 14:41:52 -0400 (EDT) Date: Thu, 17 Jul 2003 14:41:52 -0400 From: Andrew Sullivan To: pgsql-performance@postgresql.org Subject: Re: Hardware performance Message-ID: <20030717184152.GG479@libertyrms.info> Mail-Followup-To: Andrew Sullivan , pgsql-performance@postgresql.org References: <004b01c34c0f$256bfb80$0600a8c0@home01> <3F162B7D.1020106@joeconway.com> <1058428609.4289.5.camel@fuji.krosing.net> <3F16B971.7050104@joeconway.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <3F16B971.7050104@joeconway.com> User-Agent: Mutt/1.5.4i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/274 X-Sequence-Number: 2567 On Thu, Jul 17, 2003 at 07:57:53AM -0700, Joe Conway wrote: > > As I said, I've never personally found it necessary to move WAL off to a > different physical drive. What do you think is the best configuration On our Solaris test boxes (where, alas, we do not have the luxury of 1/2 TB external RAID boxes :-( ), putting WAL on a disk of its own yielded something like 30% improvement in throughput on high transaciton volumes. So it's definitely important in some cases. A ---- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada M2P 2A8 +1 416 646 3304 x110