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: (view raw or whole thread)
Lists: pgsql-performance

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: | Email: adrian(at)careerjunction(dot)co(dot)za
Phone: +27 21 686 6820 | Mobile: +27 82 858 7830 | Fax: +27 21 686 6842


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-2015 The PostgreSQL Global Development Group