Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id DBF1B9FBA9F for ; Wed, 21 Feb 2007 12:41:02 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 15876-09 for ; Wed, 21 Feb 2007 12:40:50 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from locust.cns.vt.edu (locust.cns.vt.edu [198.82.169.14]) by postgresql.org (Postfix) with ESMTP id 3C1D09FB66F for ; Wed, 21 Feb 2007 12:40:50 -0400 (AST) Received: by locust.cns.vt.edu (Postfix, from userid 986) id C828E118A35; Wed, 21 Feb 2007 11:40:49 -0500 (EST) Date: Wed, 21 Feb 2007 11:40:49 -0500 From: Ray Stell To: pgsql-performance@postgresql.org Cc: "Craig A. James" Subject: Re: How to debug performance problems Message-ID: <20070221164049.GA14702@cns.vt.edu> References: <45D9E646.6060909@modgraph-usa.com> <20070221154520.GA25149@cns.vt.edu> <45DC6ECD.9000705@modgraph-usa.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <45DC6ECD.9000705@modgraph-usa.com> User-Agent: Mutt/1.5.11 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/211 X-Sequence-Number: 23265 On Wed, Feb 21, 2007 at 08:09:49AM -0800, Craig A. James wrote: > 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. I'm only clueless about the details of pg, not db perf concepts. Really, a mechanism to determine where the system is spending the response time is key. As you pointed out, the added table may not be the issue. In fact, if you can't measure where the db time is being spent you will be lucky to fix a performance issue, since you don't really know what resources need to be addressed. > so you have to dig in and find it yourself. this afternoon, maybe.