Re: disk filling up

From: Mark Kirkwood <markir(at)paradise(dot)net(dot)nz>
To: Brandon Shalton <brandon(at)cydataservices(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: disk filling up
Date: 2007-07-27 00:48:36
Message-ID: 46A940E4.40804@paradise.net.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Alvaro Herrera 2007-07-27 08:58:05 Re: User concurrency thresholding: where do I look?
Previous Message Jim Nasby 2007-07-26 23:27:59 Re: Affect of Reindexing on Vacuum Times