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 <alvhe...@commandprompt.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 >