From: Craig A. James <cjames@modgraph-usa.com>
To: Ray Stell <stellr@cns.vt.edu>
Cc: pgsql-performance@postgresql.org
Subject: Re: How to debug performance problems
Date: Wed, 21 Feb 2007 08:09:49 -0800
Message-ID: <45DC6ECD.9000705@modgraph-usa.com> (raw)
In-Reply-To: <20070221154520.GA25149@cns.vt.edu>
References: <Pine.LNX.4.62.0702191150020.15820@wr-linux02>
<45D9E646.6060909@modgraph-usa.com>
<20070221154520.GA25149@cns.vt.edu>
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
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: cjames@modgraph-usa.com, stellr@cns.vt.edu
Subject: Re: How to debug performance problems
In-Reply-To: <45DC6ECD.9000705@modgraph-usa.com>
* 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