Re: disk filling up

Список
Период
Сортировка
От Mark Kirkwood
Тема Re: disk filling up
Дата
Msg-id 46A940E4.40804@paradise.net.nz
обсуждение исходный текст
Ответ на disk filling up  ("Brandon Shalton")
Ответы Re: disk filling up  (Yudhvir Singh Sidhu)
Список pgsql-performance
Дерево обсуждения
disk filling up  ("Brandon Shalton", )
 Re: disk filling up  (Bill Moran, )
 Re: disk filling up  (Mark Lewis, )
 Re: disk filling up  ("Joshua D. Drake", )
  Re: disk filling up  ("Merlin Moncure", )
   Re: disk filling up  (Tom Lane, )
    Re: disk filling up  ("Merlin Moncure", )
 Re: disk filling up  (Mark Kirkwood, )
  Re: disk filling up  (Yudhvir Singh Sidhu, )
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 по дате отправления:

Предыдущее
От: Yudhvir Singh Sidhu
Дата:
Сообщение: Re: disk filling up
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: User concurrency thresholding: where do I look?