Received: from localhost (unknown [200.46.204.191])
	by postgresql.org (Postfix) with ESMTP id F14CA2E411B
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Wed, 23 Jan 2008 16:59:55 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024)
	with ESMTP id 94715-02 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Wed, 23 Jan 2008 16:59:51 -0400 (AST)
Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130])
	by postgresql.org (Postfix) with ESMTP id 463172E367A
	for <pgsql-performance@postgresql.org>;
	Wed, 23 Jan 2008 16:25:52 -0400 (AST)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m0NKPox5024996
	for <pgsql-performance@postgresql.org>;
	Wed, 23 Jan 2008 15:25:51 -0500 (EST)
To: pgsql-performance Performance <pgsql-performance@postgresql.org>
Subject: Re: Vacuum and FSM page size 
In-reply-to: <E7A5FF07-C603-4B4C-ABC7-C280109E3351@kcilink.com> 
References: <F6B04D920899DF47B1E1A4F40415167E3D4299@gaia.nexus-ag.com>
	<E7A5FF07-C603-4B4C-ABC7-C280109E3351@kcilink.com>
Comments: In-reply-to Vivek Khera <khera@kcilink.com>
	message dated "Wed, 23 Jan 2008 14:22:20 -0500"
Date: Wed, 23 Jan 2008 15:25:50 -0500
Message-ID: <24995.1201119950@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200801/202
X-Sequence-Number: 28441

Vivek Khera <khera@kcilink.com> writes:
> On Jan 23, 2008, at 1:29 PM, Thomas Lozza wrote:
>> We have an installation of Postgres 8.1.2 (32bit on Solaris 9) with  
>> ...

> it sounds to me like your autovacuum is not running frequently enough.

Yeah.  The default autovac settings in 8.1 are extremely conservative
(in the direction of not letting autovac eat many cycles), so a
high-traffic installation will need to adjust them to keep from falling
behind.

			regards, tom lane