Re: VACUUM VERBOSE FSM info

Alvaro Herrera wrote:
> On Sat, Apr 23, 2005 at 04:55:37PM -0400, Bruce Momjian wrote:
>
> One question,
>
> >     INFO:  free space map contains information about:
> >     49 relations, limit 1000 relations
> >     35 pages with free space, 784 pages (with overhead)
>                                   ^^^^^^^^^
> >     784 pages required to track all freespace, limit 18000 pages (171 kB)
>
> What does that number mean?  Why not simply

Well, the number you highlighted might not equal the number on the next
line if you don't have enough entries to store all the free space, e.g.:

    INFO:  free space map contains information about:
    49 relations, limit 1000 relations
    14024 pages with free space, 18000 pages (with overhead)
    19300 pages required to track all freespace, limit 18000 pages (171 kB)

Does that help?  Let me add the words "total pages used":

    INFO:  free space map contains information about:
    49 relations, limit 1000 relations
    14024 pages with free space, 18000 total pages used (including overhead)
    19300 pages required to track all freespace, limit 18000 pages (171 kB)

> >     49 relations, limit 1000 relations
> >     35 pages with free space, limit 784 pages
> >       Total memory used 171 kB
>
> ?

OK, sure.  Done.

    INFO:  free space map contains information about:
    51 relations, limit 1000 relations
    36 pages with free space, 816 total pages used (including overhead)
    816 pages required to track all freespace, limit 18000 pages
    171 kB memory used

> Also, non-main messages should end with a period according to message
> style guidelines.

Uh, I am confused on that. The docs say:

    Primary error messages: Do not capitalize the first letter. Do not end a
    message with a period. Do not even think about ending a message with an
    exclamation point.

    Detail and hint messages: Use complete sentences, and end each with a
    period. Capitalize the first word of sentences.

Should the "memory used" line be a hint?

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073