DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding;
	b=ulDPMLVEJGMQvIs2jnT55NVV994gICvcWprYhrsstRKaNvfRIV6RzaqkTX2B9AwKcNpLfugnHyhhHIM+VhROrFGT0lFGUisbk9KehDRhIpkhe9vfiXVhAaSvQWTUUCQT0+ERSrimoFqGH/eFW+qcZ0l19/erZJT4AhJhwqT9IjI=
Message-ID: <46A8B87D.3030303@gmail.com>
Date: Thu, 26 Jul 2007 20:36:37 +0530
From: Yudhvir Singh Sidhu <ysidhu@gmail.com>
User-Agent: Thunderbird 2.0.0.5 (Windows/20070716)
MIME-Version: 1.0
To: Mark Kirkwood <markir@paradise.net.nz>
CC: Brandon Shalton <brandon@cydataservices.com>,
	pgsql-performance@postgresql.org
Subject: Re: disk filling up
References: <009c01c7cfa0$ab526810$fc01a8c0@blaptop>
	<46A940E4.40804@paradise.net.nz>
In-Reply-To: <46A940E4.40804@paradise.net.nz>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Mark Kirkwood wrote:
> Brandon Shalton wrote:
>> Hello all,
>>
>> My hard disk is filling up in the /base  directory  to where it has 
>> consumed all 200gig of that drive.
>>
>> All the posts that i see keep saying move to a bigger drive, but at 
>> some point a bigger drive would just get consumed.
>>
>> How can i keep the disk from filling up other than get like a half TB 
>> setup just to hold the ./base/*  folder
>>
>
> Two things come to mind:
>
> - Vacuum as already mentioned by others.
> - Temporary sort files from queries needing to sort massive amounts of 
> data.
>
> But you need to help us out by supplying more info...
>
> Cheers
>
> Mark
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>               http://archives.postgresql.org
>
Try fsck-ing and do a df before and after and tell us if that makes a 
difference.

Yudhvir