| From: | Adrian Moisey <adrian(at)careerjunction(dot)co(dot)za> |
|---|---|
| To: | Bill Moran <wmoran(at)collaborativefusion(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: db size |
| Date: | 2008-04-17 06:28:42 |
| Message-ID: | 4806EE1A.8010400@careerjunction.co.za |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)careerjunction(dot)co(dot)za
Phone: +27 21 686 6820 | Mobile: +27 82 858 7830 | Fax: +27 21 686 6842
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Smith | 2008-04-17 07:58:43 | Strange behavior: pgbench and new Linux kernels |
| Previous Message | Andrew Sullivan | 2008-04-17 03:19:47 | Re: Oddly slow queries |