Unexpected disk space growth controlling measures

From: "Gnanakumar" <gnanam(at)zoniac(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Unexpected disk space growth controlling measures
Date: 2010-07-31 05:18:10
Message-ID: 002301cb306f$c8967dc0$59c37940$@com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Marlowe 2010-07-31 06:34:24 Re: Unexpected disk space growth controlling measures
Previous Message Kevin Grittner 2010-07-30 18:06:55 Re: Connection pooling for a mixture of lightweight and heavyweight jobs?