VACUUM VERBOSE 8.1dev

Hello,

It seems the new VACUUM VERBOSE output is not quite as helpful as 8.0.
In 8.0 I get a nice output at the end like this:

INFO:  free space map: 1377 relations, 22478 pages stored; 44112 total 
pages needed
DETAIL:  Allocated FSM size: 100000 relations + 2000000 pages = 17702 kB 
shared memory.

Which tells me exactly what I need to do with max_fsm_pages/relations.

The new output appears:

booktown=# VACUUM FULL VERBOSE books ;
INFO:  vacuuming "public.books"
INFO:  "books": found 32804 removable, 14 nonremovable row versions in 
242 pages
DETAIL:  0 dead row versions cannot be removed yet.
Nonremovable row versions range from 48 to 72 bytes long.
There were 0 unused item pointers.
Total free space (including removable row versions) is 1845484 bytes.
241 pages are or will become empty, including 241 at the end of the table.
1 pages containing 6768 free bytes are potential move destinations.

I am sure the above tells me the same thing but not as easily.

Comments?

Sincerely,

Joshua D. Drake

-- 
Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/