Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: select on 1milion register = 6s
- From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
- To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
- Cc: Bruno Rodrigues Siqueira <bruno(at)ravnus(dot)com>, pgsql-performance(at)postgresql(dot)org
- Subject: Re: select on 1milion register = 6s
- Date: Sun, 29 Jul 2007 14:02:20 -0400
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.
- References:
- Re: select on 1milion register = 6s
- From: Craig James
- RES: select on 1milion register = 6s
- From: Bruno Rodrigues Siqueira
- Re: select on 1milion register = 6s
- From: Scott Marlowe
- Re: select on 1milion register = 6s
- Prev by Date: RES: RES: select on 1milion register = 6s
- Next by Date: Re: RES: RES: select on 1milion register = 6s
- Previous by thread: Re: select on 1milion register = 6s
- Next by thread: Re: select on 1milion register = 6s
- Indexes: