Confused about FSM numbers

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: Confused about FSM numbers
Date: 2005-11-30 14:56:48
Message-ID: 200511301556.48427.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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?

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2005-11-30 15:16:19 Re: Confused about FSM numbers
Previous Message Bricklen Anderson 2005-11-30 14:47:35 Re: upgrade database to 8.1 - 2GB file limit (pg_dump)