Re: VACUUM VERBOSE FSM info - Mailing list pgsql-patches

From Tom Lane
Subject Re: VACUUM VERBOSE FSM info
Date
Msg-id 23725.1114298288@sss.pgh.pa.us
Whole thread Raw
In response to Re: VACUUM VERBOSE FSM info  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: VACUUM VERBOSE FSM info  (Bruce Momjian <pgman@candle.pha.pa.us>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: VACUUM VERBOSE FSM info
Next
From: Bruce Momjian
Date:
Subject: Re: VACUUM VERBOSE FSM info