Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 21BD52E00ED for ; Mon, 14 Apr 2008 03:39:53 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 91284-02-8 for ; Mon, 14 Apr 2008 03:39:50 -0300 (ADT) X-Greylist: delayed 00:06:36.333157 by SQLgrey-1.7.5 Received: from cptwks26.careerjunction.local (unknown [196.212.105.173]) by developer.postgresql.org (Postfix) with ESMTP id 53C492E003B for ; Mon, 14 Apr 2008 03:36:44 -0300 (ADT) Received: from [127.0.0.1] (localhost [127.0.0.1]) by cptwks26.careerjunction.local (Postfix) with ESMTP id 376E1B7B9F for ; Mon, 14 Apr 2008 08:29:57 +0200 (SAST) Message-ID: <4802F9E4.3000704@careerjunction.co.za> Date: Mon, 14 Apr 2008 08:29:56 +0200 From: Adrian Moisey User-Agent: Thunderbird 2.0.0.12 (X11/20080227) MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: db size Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/163 X-Sequence-Number: 29656 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