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: (view raw, whole thread or download thread mbox)
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?
Try fsck-ing and do a df before and after and tell us if that makes a 


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-2017 The PostgreSQL Global Development Group