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 D13B4CC863 for ; Thu, 17 Jul 2003 07:58:54 +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 07927-08 for ; Thu, 17 Jul 2003 07:59:11 +0000 (GMT) Received: from fuji.krosing.net (unknown [194.204.44.118]) by svr1.postgresql.org (Postfix) with ESMTP id 92222CC8F3 for ; Thu, 17 Jul 2003 04:58:42 -0300 (ADT) Received: from fuji.krosing.net (localhost.localdomain [127.0.0.1]) by fuji.krosing.net (8.12.8/8.12.8) with ESMTP id h6H7uphY004623; Thu, 17 Jul 2003 10:56:51 +0300 Received: (from hannu@localhost) by fuji.krosing.net (8.12.8/8.12.8/Submit) id h6H7unD7004621; Thu, 17 Jul 2003 10:56:49 +0300 X-Authentication-Warning: fuji.krosing.net: hannu set sender to hannu@tm.ee using -f Subject: Re: Hardware performance From: Hannu Krosing To: Joe Conway Cc: pgsql-performance@postgresql.org In-Reply-To: <3F162B7D.1020106@joeconway.com> References: <004b01c34c0f$256bfb80$0600a8c0@home01> <3F162B7D.1020106@joeconway.com> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1058428609.4289.5.camel@fuji.krosing.net> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.3 Date: 17 Jul 2003 10:56:49 +0300 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/242 X-Sequence-Number: 2535 Joe Conway kirjutas N, 17.07.2003 kell 07:52: > To an extent it depends on how big the drives are and how large you > expect the database to get. For maximal performance you want RAID 1+0 > for data and WAL; and you want OS, data, and WAL each on their own > drives. So with 5 drives one possible configuration is: > > 1 drive OS: OS on it's own drive makes it easy to upgrade, or restore > the OS from CD if needed > 2 drives, RAID 1+0: WAL > 2 drives, RAID 1+0: data How do you do RAID 1+0 with just two drives ? -------------- Hannu