Re: Confused about FSM numbers

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Confused about FSM numbers
Дата
Msg-id 16683.1133363779@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Confused about FSM numbers  (Peter Eisentraut <peter_e@gmx.net>)
Список 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

В списке pgsql-admin по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Confused about FSM numbers
Следующее
От: "Tomeh, Husam"
Дата:
Сообщение: Re: upgrade database to 8.1 - 2GB file limit (pg_dump)