Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 3883447580D
	for <pgsql-sql@postgresql.org>; Sat,  3 Aug 2002 19:39:30 -0400 (EDT)
Received: from nirvana.dataparty.no (v097b.studby.ntnu.no [129.241.151.97])
	by postgresql.org (Postfix) with SMTP id CBBF5475165
	for <pgsql-sql@postgresql.org>; Sat,  3 Aug 2002 19:39:25 -0400 (EDT)
Received: (qmail 10160 invoked from network); 3 Aug 2002 23:39:26 -0000
Received: from v107b.studby.ntnu.no (HELO speed) (129.241.151.107)
	by v097b.studby.ntnu.no with SMTP; 3 Aug 2002 23:39:26 -0000
Message-ID: <038901c23b47$00d2d890$6b97f181@speed>
From: "Kristian Eide" <kreide@online.no>
To: "Joe Conway" <mail@joeconway.com>
Cc: "Ken Corey" <ken@kencorey.com>, <pgsql-sql@postgresql.org>
References: <035d01c23b2f$c5d49420$6b97f181@speed>
	<1028412884.28635.22.camel@kenlinux.bithub.org>
	<037901c23b3e$d542a140$6b97f181@speed>
	<3D4C60ED.7060402@joeconway.com>
Subject: Re: VACUUM not doing its job?
Date: Sun, 4 Aug 2002 01:39:26 +0200
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200208/69
X-Sequence-Number: 8915

> 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