Scott Marlowe wrote:
> On 7/28/07, Bruno Rodrigues Siqueira <bruno(at)ravnus(dot)com> wrote:
> > stats_start_collector = off
> > #stats_command_string = off
> > #stats_block_level = off
> > #stats_row_level = off
> > #stats_reset_on_server_start = off
> I think you need stats_row_level on for autovacuum, but I'm not 100% sure.
That's correct (of course you need "start_collector" on as well). Most
likely, autovacuum is not even running.
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
In response to
pgsql-performance by date
|Next:||From: Decibel!||Date: 2007-07-30 01:29:26|
|Subject: Re: RES: RES: select on 1milion register = 6s|
|Previous:||From: Bruno Rodrigues Siqueira||Date: 2007-07-29 16:44:23|
|Subject: RES: RES: select on 1milion register = 6s|