Re: Vacuum and FSM page size

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: pgsql-performance Performance <pgsql-performance@postgresql.org>
Date: 2008-01-23T20:25:50Z
Lists: pgsql-performance
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