X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 706B854C55 for ; Wed, 23 Feb 2005 19:51:10 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 13656-05 for ; Wed, 23 Feb 2005 19:51:01 +0000 (GMT) Received: from mail3.panix.com (mail3.panix.com [166.84.1.74]) by svr1.postgresql.org (Postfix) with ESMTP id A039F54C58 for ; Wed, 23 Feb 2005 19:51:00 +0000 (GMT) Received: from panix1.panix.com (panix1.panix.com [166.84.1.1]) by mail3.panix.com (Postfix) with ESMTP id E500298214; Wed, 23 Feb 2005 14:51:00 -0500 (EST) Received: (from adler@localhost) by panix1.panix.com (8.11.6p3/8.8.8/PanixN1.1) id j1NJp0g28778; Wed, 23 Feb 2005 14:51:00 -0500 (EST) Date: Wed, 23 Feb 2005 14:50:59 -0500 From: Michael Adler To: John Allgood Cc: pgsql-performance@postgresql.org Subject: Re: Peformance Tuning Opterons/ Hard Disk Layout Message-ID: <20050223195059.GA5334@pobox.com> References: <421cca80.3da18bb5.6940.3b12@smtp.gmail.com> <21021.1109183848@sss.pgh.pa.us> <421CD668.7010503@turbocorp.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <421CD668.7010503@turbocorp.com> User-Agent: Mutt/1.4.2.1i X-Hashcash: 1:20:050223:john@turbocorp.com::GFVLB3l4ka5B0+85:0000000000000000000 0000000000000000000000000p/h X-Hashcash: 1:20:050223:pgsql-performance@postgresql.org::GFVLB3l4ka5B0+85:00000 0000000000000000000000001+Om X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200502/337 X-Sequence-Number: 10666 On Wed, Feb 23, 2005 at 02:15:52PM -0500, John Allgood wrote: > using custom scripts. Maybe I have given a better explanation of the > application. my biggest concern is how to partition the shared storage > for maximum performance. Is there a real benifit to having more that one > raid5 partition or am I wasting my time. I think the simplest and most generic solution would be to put the OS and pg_xlog on a RAID 1 pair and dedicate the rest of the drives to RAID 5 or RAID 1+0 (striped set of mirrors) array. Depending on the nature of your work, you may get better performance by placing individual tables/indices on dedicated spindles for parallel access. -Mike Adler