Re: disk space usage unexpected

[Ben Chobot <bench@xxxxxxxxxxxxxxx>]

On Feb 15, 2010, at 1:25 PM, Rose Zhou wrote:

Thanks Ben:

 

I will adjust the auto vacuum parameters. It is on now, maybe not frequently enough.

How to get the disk space back to OS? Will a Vacuum Full Verbose get the disk space back to OS?

 

 

Yes, but it might bloat your indexes. Do you actually need to get your disk space back? If you did, would the database just eat it up again after more activity?