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

Re: disk filling up

From: Yudhvir Singh Sidhu <ysidhu(at)gmail(dot)com>
To: Mark Kirkwood <markir(at)paradise(dot)net(dot)nz>
Cc: Brandon Shalton <brandon(at)cydataservices(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: disk filling up
Date: 2007-07-26 15:06:37
Message-ID: 46A8B87D.3030303@gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
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

In response to

pgsql-performance by date

Next:From: Simon RiggsDate: 2007-07-26 15:25:31
Subject: Re: User concurrency thresholding: where do I look?
Previous:From: Joshua D. DrakeDate: 2007-07-26 14:47:08
Subject: Re: disk filling up

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