Postgres Pro
Downloads
Home   >   mailing lists

Confused about FSM numbers - Mailing list pgsql-admin

From Peter Eisentraut
Subject Confused about FSM numbers
Date
Msg-id 200511301556.48427.peter_e@gmx.net
Whole thread Raw
Responses Re: Confused about FSM numbers  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view 
I have never figured out what the FSM numbers printed by VACUUM VERBOSE really
meant.  I have for example,

INFO:  free space map: 101 relations, 150 pages stored; 1664 total pages
needed

What exactly does that last number mean?  I have 20000 pages configured for
the FSM, so if it needs 1664, why does it only take 150?

pgsql-admin by date:

Previous
From: Bricklen Anderson
Date:
Subject: Re: upgrade database to 8.1 - 2GB file limit (pg_dump)
Next
From: Tom Lane
Date:
Subject: Re: Confused about FSM numbers