X-Original-To: pgsql-performance@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 1B8AB474E5C for ; Thu, 20 Feb 2003 18:55:28 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 60950-03 for ; Thu, 20 Feb 2003 18:55:17 -0500 (EST) Received: from mail.libertyrms.com (unknown [209.167.124.227]) by postgresql.org (Postfix) with ESMTP id 6A353475B8C for ; Thu, 20 Feb 2003 18:49:25 -0500 (EST) Received: from andrew by mail.libertyrms.com with local (Exim 3.22 #3 (Debian)) id 18m0RU-0000rf-00 for ; Thu, 20 Feb 2003 18:49:28 -0500 Date: Thu, 20 Feb 2003 18:49:28 -0500 From: Andrew Sullivan To: pgsql-performance@postgresql.org Subject: Re: Tuning scenarios (was Changing the default Message-ID: <20030220184928.D30080@mail.libertyrms.com> Mail-Followup-To: Andrew Sullivan , pgsql-performance@postgresql.org References: <303E00EBDD07B943924382E153890E5434A909@cuthbert.rcsinc.local> <200302140936.02011.josh@agliodbs.com> <1045778701.14518.81.camel@camel> <200302201433.02654.josh@agliodbs.com> <1045784144.15881.92.camel@camel> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <1045784144.15881.92.camel@camel>; from xzilla@users.sourceforge.net on Thu, Feb 20, 2003 at 06:35:44PM -0500 X-Virus-Scanned: by amavisd-new X-Archive-Number: 200302/142 X-Sequence-Number: 1198 On Thu, Feb 20, 2003 at 06:35:44PM -0500, Robert Treat wrote: > Do you know how well those numbers hold up under scsi and/ or raid based > system? (I'd assume anyone doing serious work would run scsi) On some Sun E450s we have used, the machines are unusable for any load with xlog on the same disk (in the case I'm remembering, these are older 5400 RPM drives). Moving the xlog changed us for something like 10tps to something like 30tps in one seat-of-the-pants case. Sorry I can't be more specific. > ok (playing a bit of devil's advocate here), but you have two possible > points of failure, the data disk and the xlog disk. If either one goes, > your in trouble. OTOH if you put the OS disk on one drive and it goes, > your database and xlog are still safe on the other drive. If you're really worried about that, use RAID 1+0. A -- ---- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada M2P 2A8 +1 416 646 3304 x110