db size - Mailing list pgsql-performance

From Adrian Moisey
Subject db size
Date
Msg-id 4802F9E4.3000704@careerjunction.co.za
Whole thread Raw
Responses Re: db size
Re: db size
Re: db size
Re: db size
List 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 by date:

Previous
From: PFC
Date:
Subject: Re: Cached Query Plans
Next
From: Vinubalaji Gopal
Date:
Subject: Re: db size