Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id A9EF7632743
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Sat, 31 Jul 2010 02:18:28 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
	with ESMTP id 01887-06 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Sat, 31 Jul 2010 05:18:21 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from rs73.luxsci.com (rs73.luxsci.com [64.49.254.135])
	by mail.postgresql.org (Postfix) with ESMTP id 5D1D96326B4
	for <pgsql-admin@postgresql.org>; Sat, 31 Jul 2010 02:18:21 -0300 (ADT)
Received: from GNANAM (ABTS-TN-Static-186.58.165.122.airtelbroadband.in
	[122.165.58.186] (may be forged)) (authenticated bits=0)
	by rs73.luxsci.com (8.13.8/8.13.8) with ESMTP id o6V5IDCE003921;
	Sat, 31 Jul 2010 00:18:18 -0500
Reply-To: <gnanam@zoniac.com>
From: "Gnanakumar" <gnanam@zoniac.com>
To: <pgsql-admin@postgresql.org>
Subject: Unexpected disk space growth controlling measures
Date: Sat, 31 Jul 2010 10:48:10 +0530
Organization: Zoniac Software Private Limited
Message-ID: <002301cb306f$c8967dc0$59c37940$@com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
X-Mailer: Microsoft Office Outlook 12.0
Thread-Index: Acswb8QlZzNNPegsS2SdsRt9ya4VFw==
Content-Language: en-us
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.8 tagged_above=-10 required=5 tests=BAYES_50=0.8
X-Spam-Level: 
X-Archive-Number: 201007/226
X-Sequence-Number: 35245

Hi,

What are all the controlling factors/measures that one should consider/take
into account, when there is an unexpected growth in disk space usage of the
database?

Some of the factors that comes to my mind immediately are:
1) Running autovacuum daemon aggressively
2) Setting/tuning appropriate value for the parameters "max_fsm_pages" and
"max_fsm_relations"

Is there any other factors that I need to consider apart from the above? 

Hope experts can help me in the right direction.

Regards,
Gnanam