Re: Interpreting vacuum verbosity

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Interpreting vacuum verbosity
Дата
Msg-id 19791.1083976646@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Interpreting vacuum verbosity  ("Ed L." <pgsql@bluepolka.net>)
Список pgsql-general
Jeff Boes <jboes@nexcerpt.com> writes:
> Tom Lane wrote:
>> INFO:  free space map: 280 relations, 520 pages stored; 4720 total pages needed
>> DETAIL:  Allocated FSM size: 1000 relations + 20000 pages = 178 kB shared memory.

> And I would assume that if I have three databases defined on my server,
> I should run this for all three and sum the results?

No, the quoted results are cluster-wide.

It is a good idea to vacuum all three databases and then look at the
final results, just to make sure you have reasonably up-to-date info
about every table.  But you don't need to sum anything.

            regards, tom lane

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

Предыдущее
От: Dennis Gearon
Дата:
Сообщение: Re: graphical ERD tool
Следующее
От: Denis Braekhus
Дата:
Сообщение: Re: vacuumdb is failing with NUMBER OF INDEX TUPLES NOT