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 16AA15282E
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Wed, 22 Jun 2005 23:31:38 -0300 (ADT)
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 95110-09
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Thu, 23 Jun 2005 02:31:28 +0000 (GMT)
Received: from mxsf16.cluster1.charter.net (mxsf16.cluster1.charter.net
	[209.225.28.216])
	by svr1.postgresql.org (Postfix) with ESMTP id 1043552835
	for <pgsql-performance@postgresql.org>;
	Wed, 22 Jun 2005 23:31:25 -0300 (ADT)
Received: from mxip04a.cluster1.charter.net (mxip04a.cluster1.charter.net
	[209.225.28.134])
	by mxsf16.cluster1.charter.net (8.12.11/8.12.11) with ESMTP id
	j5N2VRc9020753
	for <pgsql-performance@postgresql.org>; Wed, 22 Jun 2005 22:31:27 -0400
Received: from pc-68-118-180-13.will.ct.charter.com (HELO [192.168.116.102])
	(68.118.180.13)
	by mxip04a.cluster1.charter.net with ESMTP; 22 Jun 2005 22:31:28 -0400
X-IronPort-AV: i="3.93,222,1115006400";
	d="scan'208"; a="396719937:sNHT15733068"
Message-ID: <42BA1F01.1010700@NarrowPathInc.com>
Date: Wed, 22 Jun 2005 22:31:29 -0400
From: Keith Worthington <KeithW@NarrowPathInc.com>
Reply-To: KeithW@NarrowPathInc.com
Organization: Narrow Path, Inc.
User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Frank Wiles <frank@wiles.org>
Cc: pgsql-performance@postgresql.org
Subject: Re: Performance Tuning Article
References: <20050622095227.05938982.frank@wiles.org>
	<200506221016.03808.josh@agliodbs.com>
	<20050622124232.71b05e3f.frank@wiles.org>
In-Reply-To: <20050622124232.71b05e3f.frank@wiles.org>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.051 tagged_above=0 required=5 tests=AWL
X-Spam-Level: 
X-Archive-Number: 200506/446
X-Sequence-Number: 13083



>>>  I've put together a short article and posted it online regarding
>>>  performance tuning PostgreSQL in general.  I believe it helps to
>>>  bring together the info in a easy to digest manner. I would
>>>  appreciate any feedback, comments, and especially any technical
>>>  corrections.
>>
>>Looks nice. You should mark the link to the perf tips at Varlena.com
>>as  "PostgreSQL 7.4" and augment it with the current version here:
>>www.powerpostgresql.com/PerfList
>>as well as the Annotated .Conf File:
>>www.powerpostgresql.com/Docs
> 
> 
>   Thanks! These changes have been incorporated. 
>  
> 
>>For my part, I've generally seen that SATA disks still suck for
>>read-write  applications.   I generally rate 1 UltraSCSI = 2 SATA
>>disks for anything but  a 99% read application.
> 
> 
>   I'll work this bit of wisdom in later tonight. Thanks again for the
>   feedback. 
> 
>  ---------------------------------
>    Frank Wiles <frank@wiles.org>
>    http://www.wiles.org
>  ---------------------------------

Frank,

A couple of things I wish I had been told when I started asking how to 
configure a new machine.

Use RAID 10 (striping across mirrored disks)
  or RAID 0+1 (mirror a striped array) for your data.
Use RAID 1 (mirror) for your OS
Use RAID 1 (mirror) for the WAL.

Don't put anything else on the array holding the WAL.

There have been problems with Xeon processors.

-- 
Kind Regards,
Keith