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  (Richard Huxton <dev@archonet.com>)
Список 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 по дате отправления:

Предыдущее
От: Andrew Sullivan
Дата:
Сообщение: Re: Oddly slow queries
Следующее
От: Greg Smith
Дата:
Сообщение: Strange behavior: pgbench and new Linux kernels