Re: disk filling up

Поиск
Список
Период
Сортировка
От Bill Moran
Тема Re: disk filling up
Дата
Msg-id 20070726093432.bbb28fea.wmoran@collaborativefusion.com
обсуждение исходный текст
Ответ на disk filling up  ("Brandon Shalton" <brandon@cydataservices.com>)
Список pgsql-performance
In response to "Brandon Shalton" <brandon@cydataservices.com>:

> 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

Are you vacuuming regularly?  What is the output of vacuum verbose.

If table bloat (fixed by correctly vacuuming) is not your problem, then
you either need to implement a data expiration policy to get rid of
old data, or increase the amount of storage to accommodate the data
you want to keep.

--
Bill Moran
Collaborative Fusion Inc.
http://people.collaborativefusion.com/~wmoran/

wmoran@collaborativefusion.com
Phone: 412-422-3463x4023

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Brandon Shalton"
Дата:
Сообщение: disk filling up
Следующее
От: "Jignesh K. Shah"
Дата:
Сообщение: Re: User concurrency thresholding: where do I look?