From: Joe Conway <mail@joeconway.com>
To: Kristian Eide <kreide@online.no>
Cc: Ken Corey <ken@kencorey.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: VACUUM not doing its job?
Date: Sat, 03 Aug 2002 17:32:52 -0700
Message-ID: <3D4C7634.5050105@joeconway.com> (raw)
References: <035d01c23b2f$c5d49420$6b97f181@speed>
<1028412884.28635.22.camel@kenlinux.bithub.org>
<037901c23b3e$d542a140$6b97f181@speed>
<3D4C60ED.7060402@joeconway.com>
<038901c23b47$00d2d890$6b97f181@speed>
Kristian Eide wrote:
> Thanks, very helpful, although there does not seem to be much description of
> what the two free space map options in postgresql.conf actually do. Doing a
> VACUUM ANALYZE VERBOSE on my largest table gives me:
>
> NOTICE: Pages 43681: Changed 208, Empty 0; Tup 1921387: Vac 61669, Keep 0,
> UnUsed 1362341.
>
> I will try to increase the 'max_fsm_pages' option from 10000 to 500000 and
> see if that helps.
>
Note that you'll need to do a vacuum full *first* to recover the lost
space, since the free space map is populated as the tuples are actually
freed, I believe. After that you can adjust 'max_fsm_pages' and your
vacuum frequency to achieve an equilibrium.
Joe
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-sql@postgresql.org
Cc: mail@joeconway.com, kreide@online.no, ken@kencorey.com
Subject: Re: VACUUM not doing its job?
In-Reply-To: <3D4C7634.5050105@joeconway.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