Re: disk filling up - Mailing list pgsql-performance

From Mark Kirkwood
Subject Re: disk filling up
Date
Msg-id 46A940E4.40804@paradise.net.nz
Whole thread Raw
In response to disk filling up  ("Brandon Shalton" <brandon@cydataservices.com>)
Responses Re: disk filling up  (Yudhvir Singh Sidhu <ysidhu@gmail.com>)
List 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

pgsql-performance by date:

Previous
From: "Dave Dutcher"
Date:
Subject: Re: update, truncate and vacuum
Next
From: Yudhvir Singh Sidhu
Date:
Subject: Re: disk filling up