From: Stef <svb@ucs.co.za>
To: Bruno Wolff III <bruno@wolff.to>
Cc: Markus Benne <markus@m-bass.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: VACUUM FULL vs CLUSTER
Date: Fri, 23 Sep 2005 19:18:03 +0200
Message-ID: <20050923191803.14fff2a1@svb.ucs.co.za> (raw)
In-Reply-To: <20050923165952.GA7327@wolff.to>
References: <5.2.0.9.1.20050920144041.0287c300@pop.puc.cl>
<1127242399.26562.15.camel@host-140.engineering.n-able.com>
<20050923142027.GC2298@wolff.to>
<20050923181644.161bf160@svb.ucs.co.za>
<20050923165952.GA7327@wolff.to>
Bruno Wolff III mentioned :
=> > => If you have a proper FSM setting you shouldn't need to do vacuum fulls
=> > => (unless you have an older version of postgres where index bloat might
=> > => be an issue).
Thanks Alvaro and Bruno
I just want to clarify something that I also couldn't
find a clear cut answer for before.
What is a proper fsm setting?
Someone told me to set max_fsm_relations to the number of
relations in pg_class plus a few more to allow for new relations.
And max_fsm_pages to the number of rows in the biggest table I
want to vacuum, plus a few 1000's for extra room?
Where does this free space map sit? On the disk somewhere,
or in memory, or both.
I once set the max_fsm_pages very high by mistake, and postgres
then started up and used a _lot_ of shared memory, and I had to
increase shmmax. Is there abything to watch out for when bumping this
setting up a lot?
Kind Regards
Stefan
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: svb@ucs.co.za, bruno@wolff.to, markus@m-bass.com
Subject: Re: VACUUM FULL vs CLUSTER
In-Reply-To: <20050923191803.14fff2a1@svb.ucs.co.za>
* 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