I don't have too much delete and update in the middle of the day to run autovacuum, but in the night, before vacuum analyze, there is some proccess that does delete and update, then run vacuum analyze.
On Thu, Feb 19, 2009 at 5:11 PM, Scott Marlowe <scott.marl...@gmail.com>wrote: > On Thu, Feb 19, 2009 at 11:01 AM, Rafael Domiciano > <rafael.domici...@gmail.com> wrote: > > I used to run vacuum full in one of my bases, but now i'm not running > > anymore vacuum full, just vacuum analyze in the past 1 month, but the > number > > of necessary pages is increasing every day, now it's in 311264... there > is > > any problem this get increasing? > > When I runned Reindex few days ago, this number get not decreased. > > I now that vacuum full reorders the relation, but it's the only thing > that > > it does? > > Same question I had for the other poster, why are you not running > autovacuum? Has it proven itself not up to the task? >