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

Re: count(*) performance

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Brendan Duddridge <brendan(at)clickspace(dot)com>
Cc: Luke Lonergan <llonergan(at)greenplum(dot)com>, Gábriel Ákos <akos(dot)gabriel(at)i-logic(dot)hu>,pgsql-performance(at)postgresql(dot)org
Subject: Re: count(*) performance
Date: 2006-03-27 19:35:28
Message-ID: 20060327193527.GB12691@surnet.cl (view raw or flat)
Thread:
Lists: pgsql-performance
Brendan Duddridge wrote:
> Does that mean that even though autovacuum is turned on, you still  
> should do a regular vacuum analyze periodically?

No, it probably means you have set FSM settings too low, or not tuned
the autovacuum parameters to your specific situation.

A bug in the autovacuum daemon is not unexpected however, so if it
doesn't work after tuning, let us know.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

In response to

pgsql-performance by date

Next:From: Guido NeitzerDate: 2006-03-27 19:43:43
Subject: Re: count(*) performance
Previous:From: Matthew T. O'ConnorDate: 2006-03-27 19:21:38
Subject: Re: count(*) performance

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