pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Christopher Browne <cbbrowne@ca.afilias.info>
To: pgsql-performance@postgresql.org
Subject: Re: is pg_autovacuum so effective ?
Date: Wed, 23 Feb 2005 00:35:26 -0500
Message-ID: <60ll9f2601.fsf@dba2.int.libertyrms.com> (raw)
References: <cvg29i$2l69$1@news.hub.org>
	<421B9CD9.6090703@zeut.net>
	<421BD6BF.4060007@bigfoot.com>

Gaetano Mendola <mendola@bigfoot.com> writes:
> 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...

When you do a VACUUM FULL, the FSM is made irrelevant because VACUUM
FULL takes the time to reclaim all possible space without resorting to
_any_ use of the FSM.

If you VACUUM FULL, then it's of little value to bother having a free
space map because you're obviating the need to use it.

In any case, the FSM figures you get out of a VACUUM are only really
meaningful if you're moving towards the "equilibrium point" where the
FSM is large enough to cope with the growth between VACUUM cycles.
VACUUM FULL pushes the system away from equilibrium, thereby making
FSM estimates less useful.
-- 
"cbbrowne","@","ca.afilias.info"
<http://dev6.int.libertyrms.com/;
Christopher Browne
(416) 673-4124 (land)



view thread (16+ messages)  latest in thread

Message-ID: <60ll9f2601.fsf@dba2.int.libertyrms.com>
Permalink:  ../60ll9f2601.fsf@dba2.int.libertyrms.com/
Also on:    postgresql.org/message-id/60ll9f2601.fsf@dba2.int.libertyrms.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: cbbrowne@ca.afilias.info
  Subject: Re: is pg_autovacuum so effective ?
  In-Reply-To: <60ll9f2601.fsf@dba2.int.libertyrms.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox