db size

Поиск
Список
Период
Сортировка
От Adrian Moisey
Тема db size
Дата
Msg-id 4802F9E4.3000704@careerjunction.co.za
обсуждение исходный текст
Ответы Re: db size  (Vinubalaji Gopal <VGopal@abaca.com>)
Re: db size  (Craig Ringer <craig@postnewspapers.com.au>)
Re: db size  (PFC <lists@peufeu.com>)
Re: db size  (Bill Moran <wmoran@collaborativefusion.com>)
Список pgsql-performance
Hi

We currently have a 16CPU 32GB box running postgres 8.2.

When I do a pg_dump with the following parameters "/usr/bin/pg_dump -E
UTF8 -F c -b" I get a file of 14GB in size.

But the database is 110GB in size on the disk.  Why the big difference
in size?  Does this have anything to do with performance?

--
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 по дате отправления:

Предыдущее
От: PFC
Дата:
Сообщение: Re: Cached Query Plans
Следующее
От: Vinubalaji Gopal
Дата:
Сообщение: Re: db size