Re: is pg_autovacuum so effective ? - Mailing list pgsql-performance

From Gaetano Mendola
Subject Re: is pg_autovacuum so effective ?
Date
Msg-id 421BD6BF.4060007@bigfoot.com
Whole thread Raw
In response to Re: is pg_autovacuum so effective ?  ("Matthew T. O'Connor" <matthew@zeut.net>)
List 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








pgsql-performance by date:

Previous
From: Gaetano Mendola
Date:
Subject: Re: is pg_autovacuum so effective ?
Next
From: Neil Conway
Date:
Subject: Re: PostgreSQL is extremely slow on Windows