Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

Next:From: Vinubalaji GopalDate: 2008-04-14 06:55:14
Subject: Re: db size
Previous:From: PFCDate: 2008-04-12 09:13:46
Subject: Re: Cached Query Plans

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group