[Dbmail] Again: postgresql disk usage

[Roel Rozendaal - IC&S]

Hi all,

some weeks ago i posted about an issue we were experiencing with 
postgresql - the database just kept on growing while the actual amount 
of data contained remained about the same. At the beginning of this 
week the database had grown so large that we needed to dump the data, 
drop the database and then restore the dump - this made the database 
size shrink from 60 Gb to 7.5 Gb. Philip at the time recommended (1) 
running VACUUM ANALYZE VERBOSE regularly, (2) changing the 
MAX_FSM_RELATIONS and MAX_FSM_PAGES settings. With the fresh restore we 
restarted postgres having set max_fsm_relations to 1000 and 
max_fsm_pages to 2000000. Vacuum analyze is now being run every 30 
minutes.

In spite of these measures the database is growing again - at a rate of 
about 600 Mb /day. Any ideas on attacking this problem?

thanks!

regards roel