Skip site navigation (1) Skip section navigation (2)

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: 2007-07-29 18:02:20
Message-ID: 20070729180220.GA4051@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-performance
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 SiqueiraDate: 2007-07-29 16:44:23
Subject: RES: RES: select on 1milion register = 6s

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group