Re: Question on output of VACUUM VERBOSE

Поиск
Список
Период
Сортировка
От Thomas F.O'Connell
Тема Re: Question on output of VACUUM VERBOSE
Дата
Msg-id C7AE8C78-6975-11D9-90FF-000D93AE0944@sitening.com
обсуждение исходный текст
Ответ на Question on output of VACUUM VERBOSE  ("Cornelia Boenigk" <poppcorn@cornelia-boenigk.de>)
Список pgsql-general
I think that INFO gives you information about your current usage and
that DETAIL tells you what is currently set in your configuration.

In this example, the default settings appear to be sufficient for your
database. If the values in INFO were larger than the values in DETAIL,
you would want to consider increasing max_fsm_relations and
max_fsm_pages in postgresql.conf.

-tfo

--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005

On Jan 17, 2005, at 5:14 PM, Cornelia Boenigk wrote:

> Hi all
>
> I don't understand what these two lines exactly mean.
>
> INFO:  free space map: 490 relations, 13541 pages stored; 34480 total
> pages
> needed
> DETAIL: Allocated FSM size: 1000 relations + 20000 pages = 178 kB
> shared
> memory
>
> Thanks in advance
> Conni


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

Предыдущее
От: "Vladimir S. Petukhov"
Дата:
Сообщение: Change type
Следующее
От: Michael Fuhr
Дата:
Сообщение: Re: Change type