Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group