DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:cc:in-reply-to:mime-version
	:content-type:content-transfer-encoding:content-disposition
	:references;
	b=ZerK6BSKOh6ZI40aIWMd3q3bqdF4qj9y3gnKcH96Kin21hdpddliF3JxoFlLkpRLzy
	i7/ZRgpsk0Lbfo8RkYHFNfRhopgSkNLAkxz8hniTPwHFIpMiZb5JLg7RluwJjWtzGG1i
	gneQzI+Izy+DvYmqkCuOizTa2b0jmPXR1j+nY=
Message-ID: <70c01d1d0807281317j66e0df5dw35102e841a1f2b4@mail.gmail.com>
Date: Mon, 28 Jul 2008 13:17:08 -0700
From: "Mark Wong" <markwkm@gmail.com>
To: "Francisco Reyes" <lists@stringsutils.com>
Subject: Re: A guide/tutorial to performance monitoring and tuning
Cc: pgsql-performance@postgresql.org, "Greg Smith" <gsmith@gregsmith.com>
In-Reply-To: <Pine.GSO.4.64.0807220119440.24231@westnet.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <4864F7C7.3020901@celoxis.com>
	<Pine.GSO.4.64.0806291451340.12045@westnet.com>
	<6a086f711bd50831a98602d3f9ecd351@stringsutils.com>
	<Pine.GSO.4.64.0807220119440.24231@westnet.com>

On Mon, Jul 21, 2008 at 10:24 PM, Greg Smith <gsmith@gregsmith.com> wrote:
> On Mon, 21 Jul 2008, Francisco Reyes wrote:
>
>> On 2:59 pm 06/29/08 Greg Smith <gsmith@gregsmith.com> wrote:
>>>
>>> Right now I'm working with a few other people to put together a more
>>> straightforward single intro guide that should address some of the
>>> vagueness you point out here,
>>
>> Was that ever completed?
>
> Not done yet; we're planning to have a first rev done in another couple of
> weeks.  The work in progress is at
> http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server and I'm due to
> work out another set of improvements to that this week during OSCON.

I'd also like to point out we're putting together some data revolving
about software raid, hardware raid, volume management, and filesystem
performance on a system donated by HP here:

http://wiki.postgresql.org/wiki/HP_ProLiant_DL380_G5_Tuning_Guide

Note that it's also a living guide and we've haven't started covering
some of the things I just mentioned.

Regards,
Mark