Re: select on 1milion register = 6s - Mailing list pgsql-performance

From Alvaro Herrera
Subject Re: select on 1milion register = 6s
Date
Msg-id 20070729180220.GA4051@alvh.no-ip.org
Whole thread Raw
In response to Re: select on 1milion register = 6s  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List pgsql-performance
Scott Marlowe wrote:
> On 7/28/07, Bruno Rodrigues Siqueira <bruno@ravnus.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.

pgsql-performance by date:

Previous
From: "Bruno Rodrigues Siqueira"
Date:
Subject: RES: RES: select on 1milion register = 6s
Next
From: Decibel!
Date:
Subject: Re: RES: RES: select on 1milion register = 6s