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?
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
pgsql-performance by date
|Next:||From: Vinubalaji Gopal||Date: 2008-04-14 06:55:14|
|Subject: Re: db size|
|Previous:||From: PFC||Date: 2008-04-12 09:13:46|
|Subject: Re: Cached Query Plans|