Warning about max_fsm_pages: what's that?

From: Reg Me Please <regmeplease(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Warning about max_fsm_pages: what's that?
Date: 2007-11-09 10:26:21
Message-ID: 200711091126.22500.regmeplease@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all.
During a routine "VACUUM ANALYZE" I've got this message in the logs:

WARNING: relation "public.t_dati" contains more than "max_fsm_pages" pages
with useful free space
HINT: Consider compacting this relation or increasing the configuration
parameter "max_fsm_pages".

The table in question contains some 14M+ rows.

Would it be possible to get some reference or suggestion in order to
understand better the provided hint?
This is the very first time I see this message.

Many thanks.

--
Reg me Please

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2007-11-09 10:32:46 Re: configure using libxml
Previous Message König, Monika 2007-11-09 10:18:36 configure using libxml