X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.192]) by svr1.postgresql.org (Postfix) with ESMTP id BD7A5D1C50D for ; Mon, 21 Jul 2003 16:28:59 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr4.postgresql.org [64.117.224.192]) (amavisd-new, port 10024) with ESMTP id 78634-09 for ; Mon, 21 Jul 2003 16:28:58 +0000 (GMT) Received: from mail2.mediadesign.nl (md2.mediadesign.nl [212.19.205.67]) by svr1.postgresql.org (Postfix) with SMTP id C8AF2D1C4F1 for ; Mon, 21 Jul 2003 13:28:57 -0300 (ADT) Received: (qmail 1705 invoked by uid 666); 21 Jul 2003 16:28:52 -0000 Date: Mon, 21 Jul 2003 18:28:52 +0200 From: Vincent van Leeuwen To: pgsql-performance@postgresql.org Subject: Re: Tuning PostgreSQL Message-ID: <20030721162852.GN19009@md2.mediadesign.nl> Mail-Followup-To: pgsql-performance@postgresql.org References: <9B1C77393DED0D4B9DAA1AA1742942DA3BCCB1@pos_pdc.posportal.com> <014a01c34f90$74bc2c80$b696a8c0@APR> <200307210906.10226.josh@agliodbs.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <200307210906.10226.josh@agliodbs.com> User-Agent: Mutt/1.3.28i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/336 X-Sequence-Number: 2629 On 2003-07-21 09:06:10 -0700, Josh Berkus wrote: > Alexander, > > > Hmmm. Seems to me that this setup would be better than one RAID5 with three > > 36Gb disks, wouldn't you think so? With one RAID5 array, I would still have > > the data and the WAL on one volume... > > Definitely. As I've said, my experience with RAID5 is that with less than 5 > disks, it performs around 40% of a single scsi disk for large read-write > operation on Postgres. > > If you have only 3 disks, I'd advocate one disk for WAL and one RAID 1 array > for the database. > In this setup your database is still screwed if a single disk (the WAL disk) stops working. You'll have to revert to your last backup if this happens. The RAID-1 redundancy on your data disks buys you almost nothing: marginally better performance and no real redundancy should a single disk fail. I'd use RAID-5 if you absolutely cannot use more disks, but I would use RAID-10 or two RAID-1 partitions if you can afford to use 4 disks. Vincent van Leeuwen Media Design - http://www.mediadesign.nl/