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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

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