Re: disk filling up

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



In response to "Brandon Shalton" <brandon@xxxxxxxxxxxxxxxxxx>:

> 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@xxxxxxxxxxxxxxxxxxxxxxx
Phone: 412-422-3463x4023

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux