db size

From: Adrian Moisey <adrian(at)careerjunction(dot)co(dot)za>
To: pgsql-performance(at)postgresql(dot)org
Subject: db size
Date: 2008-04-14 06:29:56
Message-ID: 4802F9E4.3000704@careerjunction.co.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)careerjunction(dot)co(dot)za
Phone: +27 21 686 6820 | Mobile: +27 82 858 7830 | Fax: +27 21 686 6842

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Vinubalaji Gopal 2008-04-14 06:55:14 Re: db size
Previous Message PFC 2008-04-12 09:13:46 Re: Cached Query Plans