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: 421BD6BF.4060007@bigfoot.com (view raw or flat)
Thread:
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...




REgards
Gaetano Mendola








In response to

Responses

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-2014 The PostgreSQL Global Development Group