Re: [PERFORM] postgresql.conf setting for max_fsm_pages

2012-04-05 Thread Scott Marlowe
On Wed, Apr 4, 2012 at 3:22 AM, ahchuan wrote: > Hi All, > > > I am new in using postgresSQL, I now support a system that been > running on postgressql. Recently I found that the database are > consuming the diskspace rapidly, it starting from 9GB and it now grow > until 40GB within 4-5 month. > >

Re: [PERFORM] postgresql.conf setting for max_fsm_pages

2012-04-05 Thread Marcos Ortiz
On 04/04/2012 05:22 AM, ahchuan wrote: Hi All, I am new in using postgresSQL, I now support a system that been running on postgressql. Recently I found that the database are consuming the diskspace rapidly, it starting from 9GB and it now grow until 40GB within 4-5 month. I try to do a full

[PERFORM] postgresql.conf setting for max_fsm_pages

2012-04-05 Thread ahchuan
Hi All, I am new in using postgresSQL, I now support a system that been running on postgressql. Recently I found that the database are consuming the diskspace rapidly, it starting from 9GB and it now grow until 40GB within 4-5 month. I try to do a full vacuum to the database but then i get this