Message-ID: <45DC6ECD.9000705@modgraph-usa.com>
Date: Wed, 21 Feb 2007 08:09:49 -0800
From: "Craig A. James" <cjames@modgraph-usa.com>
User-Agent: Thunderbird 1.5.0.9 (X11/20061206)
MIME-Version: 1.0
To: Ray Stell <stellr@cns.vt.edu>
CC: pgsql-performance@postgresql.org
Subject: Re: How to debug performance problems
References: <Pine.LNX.4.62.0702191150020.15820@wr-linux02>
	<45D9E646.6060909@modgraph-usa.com>
	<20070221154520.GA25149@cns.vt.edu>
In-Reply-To: <20070221154520.GA25149@cns.vt.edu>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Ray,

> I'd like to have a toolbox prepared for when performance goes south.
> I'm clueless.  Would someone mind providing some detail about how to
> measure these four items Craig listed:

I hope I didn't give the impression that these were the only thing to look at ... those four items just popped into my head, because they've come up repeatedly in this forum.  There are surely more things that could be suspect; perhaps others could add to your list.

You can find the answers to each of the four topics I mentioned by looking through the archives of this list.  It's a lot of work.  It would be really nice if there was some full-time employee somewhere whose job was to monitor this group and pull out common themes that were put into a nice, tidy manual.  But this is open-source development, and there is no such person, so you have to dig in and find it yourself.

Craig