X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 07D51D7DA5
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Wed, 12 Oct 2005 12:34:10 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 47856-02
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Wed, 12 Oct 2005 15:34:03 +0000 (GMT)
Received: from mail.baymountain.com (mail.baymountain.com [8.7.96.19])
	by svr1.postgresql.org (Postfix) with SMTP id 6DC1AD7DDB
	for <pgsql-performance@postgresql.org>;
	Wed, 12 Oct 2005 12:34:03 -0300 (ADT)
Received: (qmail 29471 invoked by uid 504); 12 Oct 2005 15:34:01 -0000
Received: from emil@baymountain.com by mail.baymountain.com by uid 501 with
	qmail-scanner-1.16 (spamassassin: 2.53.  Clear:SA:0(0.0/7.0):.
	Processed in 0.237651 secs); 12 Oct 2005 15:34:01 -0000
Received: from unknown (HELO briggspack.com)
	(emil@briggspack.com@24.211.148.77)
	by mail.baymountain.com with SMTP; 12 Oct 2005 15:34:01 -0000
From: Emil Briggs <emil@baymountain.com>
Reply-To: emil@baymountain.com
Organization: Baymountain, Inc.
To: Csaba Nagy <nagy@ecircle-ag.com>
Subject: Re: Help tuning postgres
Date: Wed, 12 Oct 2005 11:33:56 -0400
User-Agent: KMail/1.7.1
References: <1129128315.2995.174.camel@coppola.muc.ecircle.de>
	<200510121112.11486.emil@baymountain.com>
	<1129130273.2995.177.camel@coppola.muc.ecircle.de>
In-Reply-To: <1129130273.2995.177.camel@coppola.muc.ecircle.de>
Cc: pgsql-performance@postgresql.org
MIME-Version: 1.0
Content-Type: text/plain;
  charset="utf-8"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200510121133.56955.emil@baymountain.com>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.038 required=5 tests=[AWL=-0.012,
	FORGED_RCVD_HELO=0.05]
X-Spam-Level: 
X-Archive-Number: 200510/210
X-Sequence-Number: 14978

> [snip]
>
> > Have you tried reindexing your active tables?
>
> Not yet, the db is in production use and I have to plan for a down-time
> for that... or is it not impacting the activity on the table ?
>

It will cause some performance hit while you are doing it. It sounds like 
something is bloating rapidly on your system and the indexes is one possible 
place that could be happening.