On Fri, Feb 4, 2011 at 5:35 PM, Shaun Thomas
<sthomas@peak6.com> wrote:
vacuumdb -a -v -z &>vacuum.log
And at the end of the log, it'll tell you how many pages it wants, and how many pages were available.
this is the dev, not live. but this is after it gets done with that table:
CPU 0.00s/0.00u sec elapsed 0.00 sec.
INFO: analyzing "public.fastadder_fastadderstatus"
INFO: "fastadder_fastadderstatus": scanned 2492 of 2492 pages, containing 154378 live rows and 0 dead rows; 30000 rows in sample, 154378 estimated total rows
and there's nothing at the end of the whole vacuum output about pages
actual command:
vacuumdb -U postgres -W -v -z djns4 &> vacuum.log
I tried it with all databases too
?
thanks