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?
In response to
pgsql-performance by date
|Next:||From: Rose Zhou||Date: 2010-02-17 18:43:46|
|Subject: Re: disk space usage unexpected|
|Previous:||From: Jeff||Date: 2010-02-17 13:30:07|
|Subject: bgwriter tunables vs pg_stat_bgwriter|