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
=:->