Re: unexplained autovacuum to prevent wraparound

Thanks, but I do want 1%.

On Fri, Mar 12, 2010 at 5:19 PM, Joshua D. Drake <jd(at)commandprompt(dot)com>wrote:

> On Fri, 2010-03-12 at 16:45 -0700, Gordon Shannon wrote:
> > 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);
>
> That is 1% changes. I think you want .10
>
> Sincerely,
>
> Joshua D. Drake
>
>
> >
>
>
> --
> PostgreSQL.org Major Contributor
> Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
> Consulting, Training, Support, Custom Development, Engineering
> Respect is earned, not gained through arbitrary and repetitive use or Mr.
> or Sir.
>
>

--
If I had more time, I could have written you a shorter letter. (Blaise
Pascal)