Re: VACUUM VERBOSE FSM info

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: VACUUM VERBOSE FSM info
Дата
Msg-id 23725.1114298288@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: VACUUM VERBOSE FSM info  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: VACUUM VERBOSE FSM info  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-patches
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Should the "memory used" line be a hint?

Well, the main message should fit on one line, and the rest is either
hint or detail.  In this case detail since it's all facts, not advice.
Could look like this:

INFO: free space map contains N1 pages in N2 relations
DETAIL: A total of N3 FSM page slots are in use.
A total of N4 FSM page slots are required to track all free space.
Current FSM parameters are max_fsm_pages = N5, max_fsm_relations = N6,
resulting in total memory usage of N7 kB.

(where N3 is the number including overhead, and N4 is the "requested"
number.)

You could fix it so that hints were conditionally added like

HINT: max_fsm_pages is too small, consider raising it to at least N4.

but since you seem to want to treat that as a WARNING, it'd probably
be redundant to make a HINT for it.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: VACUUM VERBOSE FSM info
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: VACUUM VERBOSE FSM info