Skip site navigation (1) Skip section navigation (2)

Re: is pg_autovacuum so effective ?

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
Subject: Re: is pg_autovacuum so effective ?
Date: 2005-02-23 01:05:03
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
Matthew T. O'Connor wrote:

> Well without thinking too much, I would first ask about your FSM
> settings?  If they aren't big enought that will cause bloat.  Try
> bumping your FSM settings and then see if you reach steady state.

FSM settings are big enough:

 max_fsm_pages                  | 2000000
 max_fsm_relations              | 1000

at least after a vacuum full I see that these numbers are an overkill...

Gaetano Mendola

In response to


pgsql-performance by date

Next:From: Butkus_CharlesDate: 2005-02-23 01:45:44
Subject: Joins, Deletes and Indexes
Previous:From: Gaetano MendolaDate: 2005-02-23 01:03:10
Subject: Re: is pg_autovacuum so effective ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group