Re: Vacuum and FSM page size - Mailing list pgsql-performance

From Tom Lane
Subject Re: Vacuum and FSM page size
Date
Msg-id 24995.1201119950@sss.pgh.pa.us
Whole thread Raw
In response to Re: Vacuum and FSM page size  (Vivek Khera <khera@kcilink.com>)
List 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

pgsql-performance by date:

Previous
From: Guy Rouillier
Date:
Subject: Re: Making the most of memory?
Next
From: "A.M."
Date:
Subject: Re: Making the most of memory?