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 80D74D1C513 for ; Mon, 21 Jul 2003 16:08:00 +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 88831-03 for ; Mon, 21 Jul 2003 16:07:55 +0000 (GMT) Received: from davinci.ethosmedia.com (unknown [209.10.40.251]) by svr1.postgresql.org (Postfix) with ESMTP id DE106D1C50D for ; Mon, 21 Jul 2003 13:07:54 -0300 (ADT) Received: from [63.195.55.98] (HELO spooky) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2) with ESMTP id 3239800; Mon, 21 Jul 2003 09:08:01 -0700 Content-Type: text/plain; charset="utf-8" From: Josh Berkus Organization: Aglio Database Solutions To: "Alexander Priem" , "Roman Fail" , , Subject: Re: Tuning PostgreSQL Date: Mon, 21 Jul 2003 09:06:10 -0700 User-Agent: KMail/1.4.3 References: <9B1C77393DED0D4B9DAA1AA1742942DA3BCCB1@pos_pdc.posportal.com> <014a01c34f90$74bc2c80$b696a8c0@APR> In-Reply-To: <014a01c34f90$74bc2c80$b696a8c0@APR> MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Message-Id: <200307210906.10226.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/335 X-Sequence-Number: 2628 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. -- Josh Berkus Aglio Database Solutions San Francisco