Re: vacuum full...

[Rafael Domiciano <rafael.domiciano@xxxxxxxxx>]

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.marlowe@xxxxxxxxx> wrote:

On Thu, Feb 19, 2009 at 11:01 AM, Rafael Domiciano
<rafael.domiciano@xxxxxxxxx> 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?