Re: unexplained autovacuum to prevent wraparound - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: unexplained autovacuum to prevent wraparound
Date
Msg-id 1268439596.592.25.camel@jd-desktop.unknown.charter.com
Whole thread Raw
In response to Re: unexplained autovacuum to prevent wraparound  (Gordon Shannon <gordo169@gmail.com>)
Responses Re: unexplained autovacuum to prevent wraparound  (Gordon Shannon <gordo169@gmail.com>)
List pgsql-general
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.

pgsql-general by date:

Previous
From: Gordon Shannon
Date:
Subject: Re: unexplained autovacuum to prevent wraparound
Next
From: "dario.ber@libero.it"
Date:
Subject: Re: Function with DEFAULT arguments