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
Message-ID: <002301cb306f$c8967dc0$59c37940$@com> (raw)
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
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-admin@postgresql.org
Cc: gnanam@zoniac.com
Subject: Re: Unexpected disk space growth controlling measures
In-Reply-To: <002301cb306f$c8967dc0$59c37940$@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