Re: disk filling up

Поиск
Список
Период
Сортировка
От Mark Kirkwood
Тема Re: disk filling up
Дата
Msg-id 46A940E4.40804@paradise.net.nz
обсуждение исходный текст
Ответ на disk filling up  ("Brandon Shalton" <brandon@cydataservices.com>)
Ответы Re: disk filling up  (Yudhvir Singh Sidhu <ysidhu@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: "Dave Dutcher"
Дата:
Сообщение: Re: update, truncate and vacuum
Следующее
От: Yudhvir Singh Sidhu
Дата:
Сообщение: Re: disk filling up