Re: vacuum full... - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: vacuum full...
Date
Msg-id dcc563d10902191211g73932526l468d9b8bd1c356ad@mail.gmail.com
Whole thread Raw
In response to Re: vacuum full...  (Rafael Domiciano <rafael.domiciano@gmail.com>)
Responses Re: vacuum full...
List pgsql-admin
On Thu, Feb 19, 2009 at 11:01 AM, Rafael Domiciano
<rafael.domiciano@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?

pgsql-admin by date:

Previous
From: Rafael Domiciano
Date:
Subject: Re: vacuum full...
Next
From: "Leticia Larrosa"
Date:
Subject: configuration related to statistics