X-Original-To: pgsql-novice-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 74B7ED1B510 for ; Thu, 2 Oct 2003 01:13:10 +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 62332-06 for ; Wed, 1 Oct 2003 22:12:27 -0300 (ADT) Received: from davinci.ethosmedia.com (unknown [209.128.84.228]) by svr1.postgresql.org (Postfix) with ESMTP id 356E3D1B513 for ; Wed, 1 Oct 2003 22:12:23 -0300 (ADT) Received: from [66.219.92.2] (HELO temoku) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2) with ESMTP id 3705295; Wed, 01 Oct 2003 18:12:58 -0700 Content-Type: text/plain; charset="iso-8859-1" From: Josh Berkus Reply-To: josh@agliodbs.com Organization: Aglio Database Solutions To: , Jason Hihn Subject: Re: Ideal Hardware? Date: Wed, 1 Oct 2003 18:10:31 -0700 User-Agent: KMail/1.4.3 Cc: "Pgsql-Novice@Postgresql. Org" References: In-Reply-To: MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200310011810.32006.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/20 X-Sequence-Number: 8457 Gord, > I vaguely remember someone (Tom?) mentioning that one of the log > files probably might want to go on its own partition.=20 That's general knowledge, but not really applicable to a fast RAID system.= =20=20=20 It's more imporant to regular-disk systems; with 4+ disk RAID, nobody has= =20 been able to demonstrate a gain from having the disk separation. > fast, rebuilding RAID 1 is a pain in the butt! My biggest RAID 10 > is about 10 GB, bundling the new partition from the new disk into > the RAID 0 is fast, rebuilding the mirror (RAID 1 part) takes 10 > hours! Dual athlon 1.6's and 1 GB of RAM, so I have lots of > horsepower. Maybe you are going with better RAID than I have, > but it seems to me that RAID 5 (with spares) is going to be better > if you ever have to rebuild. Also depends on the number of disks, the controller, and the balance of rea= d=20 vs. write activity. I've found RAID 5 with no cache to be dog-slow for OL= TP=20 (heavy write transaction) databases, and use RAID 1 for that. --=20 -Josh Berkus Aglio Database Solutions San Francisco