X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id A3C40D1B504 for ; Sun, 14 Sep 2003 04:45:05 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 42023-08 for ; Sun, 14 Sep 2003 01:44:55 -0300 (ADT) Received: from internetstaff.com (internetstaff.com [63.214.174.240]) by svr1.postgresql.org (Postfix) with ESMTP id 63203D1B4F5 for ; Sun, 14 Sep 2003 01:44:54 -0300 (ADT) Received: from spank (ip68-110-79-68.ph.ph.cox.net [68.110.79.68]) by internetstaff.com (Postfix) with ESMTP id 243A8F6A97 for ; Sat, 13 Sep 2003 21:41:55 -0700 (MST) Subject: Re: best arrangement of 3 disks for (insert) performance From: Cott Lang To: pgsql-performance@postgresql.org In-Reply-To: <60fzj2t4g6.fsf@dev6.int.libertyrms.info> References: <200309121126.29756.rj@last.fm> <60fzj2t4g6.fsf@dev6.int.libertyrms.info> Content-Type: text/plain Message-Id: <1063514688.27300.11.camel@blackbox> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.4 Date: Sat, 13 Sep 2003 21:44:48 -0700 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/213 X-Sequence-Number: 3579 > Having WAL on a separate drive from the database would be something of > a win. I'd buy that 1 disk for OS+WAL and then RAID [something] > across the other two drives for the database would be pretty helpful. Just my .02, I did a lot of testing before I deployed our ~50GB postgresql databases with various combinations of 6 15k SCSI drives. I did custom benchmarks to simulate our applications, I downloaded several benchmarks, etc. It might be a fluke, but I never got better performance with WALs on a different disk than I did with all 6 disks in a 0+1 configuration. Obviously that's not an option with 3 disks. =) I ended up going with that for easier space maintenance. Obviously YMMV, benchmark for your own situation. :)