Postgres Pro
Downloads
Home   >   mailing lists

Re: disk space usage unexpected - Mailing list pgsql-performance

From Ben Chobot
Subject Re: disk space usage unexpected
Date
Msg-id FA4CF95F-B531-4373-9A41-0EFBACFD7548@silentmedia.com
Whole thread Raw
In response to Re: disk space usage unexpected  ("Rose Zhou" <rose@anatec.com>)
Responses Re: disk space usage unexpected  ("Rose Zhou" <rose@anatec.com>)
List pgsql-performance
Tree view
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?

pgsql-performance by date:

Previous
From: Jeff
Date:
Subject: bgwriter tunables vs pg_stat_bgwriter
Next
From: "Rose Zhou"
Date:
Subject: Re: disk space usage unexpected