pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Steinar H. Gunderson <sgunderson@bigfoot.com>
To: pgsql-performance@postgresql.org
Subject: Re: WAL sync behaviour
Date: Thu, 10 Nov 2005 18:58:43 +0100
Message-ID: <20051110175843.GA6254@uio.no> (raw)
In-Reply-To: <10320.1131644655@sss.pgh.pa.us>
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>

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/



view thread (11+ messages)

Message-ID: <20051110175843.GA6254@uio.no>
Permalink:  ../20051110175843.GA6254@uio.no/
Also on:    postgresql.org/message-id/20051110175843.GA6254@uio.no

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: sgunderson@bigfoot.com
  Subject: Re: WAL sync behaviour
  In-Reply-To: <20051110175843.GA6254@uio.no>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox