Hasnul Fadhly bin Hasan wrote:
Hi Bryan,

Just wondering, i ran vacuumdb but didn't get the information that you get about the free space even when i set the verbose option. How did you get that?

Thanks,

Hasnul


I believe it is
VACUUM FULL ANALYZE VERBOSE;

At the very end you will get a listing like

INFO: free space map: 167 relations, 423 pages stored; 2912 total pages needed
DETAIL: Allocated FSM size: 1000 relations + 20000 pages = 186 kB shared memory.

(Yes, mine is done on a very static table.)

John
=:->

Attachment: signature.asc
Description: OpenPGP digital signature



Reply via email to