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/