by adrian@[EMAIL PROTECTED]
(Adrian Moisey)
Apr 17, 2008 at 08:28 AM
Hi
> Running VACUUM VERBOSE will give you a detailed view of space usage of
> each individual table.
I did that.
Not too sure what I'm looking for, can someone tell me what this means:
INFO: "blahxxx": scanned 27 of 27 pages, containing 1272 live rows and
0 dead rows; 1272 rows in sample, 1272 estimated total rows
INFO: free space map contains 4667977 pages in 1199 relations
DETAIL: A total of 4505344 page slots are in use (including overhead).
4505344 page slots are required to track all free space.
Current limits are: 15537488 page slots, 1200 relations, using 91172 kB.
--
Adrian Moisey
Systems Administrator | CareerJunction | Your Future Starts Here.
Web: www.careerjunction.co.za | Email: adrian@[EMAIL PROTECTED]
+27 21 686 6820 | Mobile: +27 82 858 7830 | Fax: +27 21 686 6842
--
Sent via pgsql-performance mailing list (pgsql-performance@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
