pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Confused about FSM numbers
2+ messages / 2 participants
[nested] [flat]

* Confused about FSM numbers
@ 2005-11-30 14:56  Peter Eisentraut <peter_e@gmx.net>
  0 siblings, 1 reply; 2+ messages in thread

From: Peter Eisentraut @ 2005-11-30 14:56 UTC (permalink / raw)
  To: 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?



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Confused about FSM numbers
@ 2005-11-30 15:16  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Peter Eisentraut <peter_e@gmx.net>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2005-11-30 15:16 UTC (permalink / raw)
  To: Peter Eisentraut <peter_e@gmx.net>; +Cc: pgsql-admin

Peter Eisentraut <peter_e@gmx.net> writes:
> 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?

The FSM allocations are quantized (16 pages per chunk IIRC).  So to
store one page for each of 101 relations you'd need 1616 page slots.
It looks like you have three more chunks than the minimum, so some
of those relations have more than 16 pages with free space, but not
very many ...

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2005-11-30 15:16 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-11-30 14:56 Confused about FSM numbers Peter Eisentraut <peter_e@gmx.net>
2005-11-30 15:16 ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox