Re: VACUUM not doing its job?

From: "Kristian Eide" <kreide(at)online(dot)no>
To: "Joe Conway" <mail(at)joeconway(dot)com>
Cc: "Ken Corey" <ken(at)kencorey(dot)com>, <pgsql-sql(at)postgresql(dot)org>
Subject: Re: VACUUM not doing its job?
Date: 2002-08-03 23:39:26
Message-ID: 038901c23b47$00d2d890$6b97f181@speed
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> 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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2002-08-04 00:31:27 Re: STATISTICS?
Previous Message Joe Conway 2002-08-03 23:02:05 Re: VACUUM not doing its job?