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 по дате отправления: