pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedConfused 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