From: Kristian Eide <kreide@online.no>
To: Joe Conway <mail@joeconway.com>
Cc: Ken Corey <ken@kencorey.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: VACUUM not doing its job?
Date: Sun, 4 Aug 2002 01:39:26 +0200
Message-ID: <038901c23b47$00d2d890$6b97f181@speed> (raw)
References: <035d01c23b2f$c5d49420$6b97f181@speed>
<1028412884.28635.22.camel@kenlinux.bithub.org>
<037901c23b3e$d542a140$6b97f181@speed>
<3D4C60ED.7060402@joeconway.com>
> You should also search the archives for threads on free space maps. You
> most likely need to increase yours. In particular, see:
> http://archives.postgresql.org/pgsql-general/2002-07/msg00972.php
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.
Regards,
Kristian
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: kreide@online.no, mail@joeconway.com, ken@kencorey.com
Subject: Re: VACUUM not doing its job?
In-Reply-To: <038901c23b47$00d2d890$6b97f181@speed>
* 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