Re: Vacuum and FSM page size

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Vivek Khera <khera@xxxxxxxxxxx> 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

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux