On Wed, Jan 20, 2010 at 3:03 PM, Carlo Stonebanks
>> Yes! You can run vacuum verbose against the regular old postgres
>> database (or just create one for testing with nothing in it) and
>> you'll still get the fsm usage numbers from that! So, no need to run
>> it against the big db. However, if regular vacuum verbose couldn't
>> finish in a week, then you've likely got vacuum and autovacuum set to
>> be too timid in their operation, and may be getting pretty bloated as
>> we speak. Once the fsm gets too blown out of the water, it's quicker
>> to dump and reload the whole DB than to try and fix it.
> My client reports this is what they actualyl do on a monthly basis.
Something is deeply wrong with your client's vacuuming policies.
In response to
pgsql-performance by date
|Next:||From: Greg Stark||Date: 2010-01-21 05:15:40|
|Subject: Re: ext4 finally doing the right thing|
|Previous:||From: Carlo Stonebanks||Date: 2010-01-20 22:26:05|
|Subject: Re: Re: New server to improve performance on our large and busy DB - advice? (v2)|