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
