Re: unexplained autovacuum to prevent wraparound

This is 8.4, there is no pg_autovacuum table. I set it like this:

alter table foo set (autovacuum_analyze_scale_factor=0.01);

On Fri, Mar 12, 2010 at 4:31 PM, Alvaro Herrera
<alvherre(at)commandprompt(dot)com>wrote:

> Gordon Shannon escribió:
>
> > One possibly interesting thing is that this seems to have started just
> after
> > I set foo's autovacuum_analyze_scale_factor to 0.01, since I wanted more
> > frequent analyze runs. I wonder if that could be related.
>
> You probably set the other values to 0, which includes the freeze age.
> You need to set it (and all other values) to -1 instead.
>
> --
> Alvaro Herrera
> http://www.CommandPrompt.com/
> PostgreSQL Replication, Consulting, Custom Development, 24x7 support
>