Re: db size
| От | Adrian Moisey |
|---|---|
| Тема | Re: db size |
| Дата | |
| Msg-id | 4806EE1A.8010400@careerjunction.co.za обсуждение исходный текст |
| Ответ на | Re: db size (Bill Moran <wmoran@collaborativefusion.com>) |
| Ответы |
Re: db size
|
| Список | 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 по дате отправления: