That looks like the fix for this, thanks! I will try to upgrade soon.
-- Gordon
On Sun, Mar 14, 2010 at 7:43 AM, Alvaro Herrera
wrote:
> Gordon Shannon escribió:
> > Ah, now I see what you meant. Forgive me, I thought you were referring
> to
> > the pg_autovacuum table in 8.3 where you have to
Gordon Shannon escribió:
> Ah, now I see what you meant. Forgive me, I thought you were referring to
> the pg_autovacuum table in 8.3 where you have to specifiy something for each
> column, and -1 says use the default. It appears in 8.4.0 I have to
> explicitly set ALL (?) other storage parameter
Ah, now I see what you meant. Forgive me, I thought you were referring to
the pg_autovacuum table in 8.3 where you have to specifiy something for each
column, and -1 says use the default. It appears in 8.4.0 I have to
explicitly set ALL (?) other storage parameters to -1 to get the default,
other
Thanks, but I do want 1%.
On Fri, Mar 12, 2010 at 5:19 PM, Joshua D. Drake 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% ch
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 Contr
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
wrote:
> Gordon Shannon escribió:
>
> > One possibly interesting thing is that this seems to have started just
> after
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 th
It appears to me that in my 8.4.0 system, autovacuum is running to prevent
wraparound contrary to the documentation. I have it set to a tables'
relfrozenxid has to get to 1.5 billion before that kicks in:
> show autovacuum_freeze_max_age;
15
> show vacuum_freeze_table_age;
13
