Unexpected disk space growth controlling measures - Mailing list pgsql-admin

From Gnanakumar
Subject Unexpected disk space growth controlling measures
Date
Msg-id 002301cb306f$c8967dc0$59c37940$@com
Whole thread Raw
Responses Re: Unexpected disk space growth controlling measures  (Scott Marlowe <scott.marlowe@gmail.com>)
List 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


pgsql-admin by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Connection pooling for a mixture of lightweight and heavyweight jobs?
Next
From: Scott Marlowe
Date:
Subject: Re: Unexpected disk space growth controlling measures