Re: disk space usage unexpected

From: Ben Chobot <bench(at)silentmedia(dot)com>
To: Rose Zhou <rose(at)anatec(dot)com>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: disk space usage unexpected
Date: 2010-02-17 18:34:17
Message-ID: FA4CF95F-B531-4373-9A41-0EFBACFD7548@silentmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Rose Zhou 2010-02-17 18:43:46 Re: disk space usage unexpected
Previous Message Jeff 2010-02-17 13:30:07 bgwriter tunables vs pg_stat_bgwriter