Re: db size - Mailing list pgsql-performance

From Adrian Moisey
Subject Re: db size
Date
Msg-id 4806EE1A.8010400@careerjunction.co.za
Whole thread Raw
In response to Re: db size  (Bill Moran <wmoran@collaborativefusion.com>)
Responses Re: db size
List pgsql-performance
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@careerjunction.co.za
Phone: +27 21 686 6820 | Mobile: +27 82 858 7830 | Fax: +27 21 686 6842

pgsql-performance by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Oddly slow queries
Next
From: Greg Smith
Date:
Subject: Strange behavior: pgbench and new Linux kernels