Skip site navigation (1) Skip section navigation (2)

Re: VACUUM VERBOSE FSM info

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
Cc: PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: VACUUM VERBOSE FSM info
Date: 2005-04-23 21:16:09
Message-ID: 200504232116.j3NLG9w29157@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-patches
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(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

Responses

pgsql-patches by date

Next:From: Alvaro HerreraDate: 2005-04-23 22:08:35
Subject: Re: VACUUM VERBOSE FSM info
Previous:From: Alvaro HerreraDate: 2005-04-23 20:59:52
Subject: Re: VACUUM VERBOSE FSM info

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group