X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by postgresql.org (Postfix) with ESMTP id 685409DC84C
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Mon, 27 Mar 2006 15:35:31 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 58690-08
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Mon, 27 Mar 2006 15:35:30 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from mx1.surnet.cl (mx1.surnet.cl [216.155.73.180])
	by postgresql.org (Postfix) with ESMTP id 519D59DCAE5
	for <pgsql-performance@postgresql.org>;
	Mon, 27 Mar 2006 15:35:27 -0400 (AST)
Received: from unknown (HELO cluster.surnet.cl) ([216.155.73.165])
	by mx1.surnet.cl with ESMTP; 27 Mar 2006 15:35:28 -0400
X-IronPort-AV: i="4.03,135,1141614000";
	d="scan'208"; a="49267840:sNHT18751048"
Received: from alvh.no-ip.org (200.126.99.207) by cluster.surnet.cl (7.0.043)
	(authenticated as alvherre@surnet.cl)
	id 43A978FD00C323C2; Mon, 27 Mar 2006 15:35:28 -0400
Received: by alvh.no-ip.org (Postfix, from userid 1000)
	id 279D4C4E9C3; Mon, 27 Mar 2006 15:35:28 -0400 (CLT)
Date: Mon, 27 Mar 2006 15:35:28 -0400
From: Alvaro Herrera <alvherre@commandprompt.com>
To: Brendan Duddridge <brendan@clickspace.com>
Cc: Luke Lonergan <llonergan@greenplum.com>,
	=?iso-8859-1?Q?G=E1briel_=C1kos?= <akos.gabriel@i-logic.hu>,
	pgsql-performance@postgresql.org
Subject: Re: count(*) performance
Message-ID: <20060327193527.GB12691@surnet.cl>
Mail-Followup-To: Brendan Duddridge <brendan@clickspace.com>,
	Luke Lonergan <llonergan@greenplum.com>,
	=?iso-8859-1?Q?G=E1briel_=C1kos?= <akos.gabriel@i-logic.hu>,
	pgsql-performance@postgresql.org
References: <C04D6B95.20285%llonergan@greenplum.com>
	<CE860B90-6CAB-441A-870B-397696599418@clickspace.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <CE860B90-6CAB-441A-870B-397696599418@clickspace.com>
User-Agent: Mutt/1.5.11+cvs20060126
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=1.804 required=5 tests=[AWL=-0.115,
	DNS_FROM_RFC_ABUSE=0.479, DNS_FROM_RFC_POST=1.44]
X-Spam-Score: 1.804
X-Spam-Level: *
X-Archive-Number: 200603/530
X-Sequence-Number: 17967

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.