Date: Thu, 10 Nov 2005 18:58:43 +0100
From: "Steinar H. Gunderson" <sgunderson@bigfoot.com>
To: pgsql-performance@postgresql.org
Subject: Re: WAL sync behaviour
Message-ID: <20051110175843.GA6254@uio.no>
Mail-Followup-To: pgsql-performance@postgresql.org
References: <20051110133241.GA4031@uio.no> <437355C6.4030604@archonet.com>
	<20051110142535.GA4530@uio.no> <20051110144309.GO9905@mathom.us>
	<1131637958.3554.75.camel@state.g2switchworks.com>
	<9791.1131640774@sss.pgh.pa.us>
	<1131642009.3554.87.camel@state.g2switchworks.com>
	<10320.1131644655@sss.pgh.pa.us>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
In-Reply-To: <10320.1131644655@sss.pgh.pa.us>
User-Agent: Mutt/1.5.11

On Thu, Nov 10, 2005 at 12:44:15PM -0500, Tom Lane wrote:
> Don't think so ... want to write something up?  Hard part is to
> figure out where to put it ...

To be honest, I think we could use a "newbie's guide to PostgreSQL
performance tuning". I've seen rather good guides for query tuning, and
guides for general performance tuning, but none that really cover both in a
coherent way. (Also, many of the ones I've seen start getting rather dated;
after bitmap index scans arrived, for instance, many of the rules with regard
to index planning probably changed.)

I'd guess http://www.powerpostgresql.com/PerfList is a rather good start for
the second part (and it's AFAICS under a free license); having something like
that in the docs (or some other document) would probably be a good start.

/* Steinar */
-- 
Homepage: http://www.sesse.net/