X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 476A75324C for ; Mon, 4 Apr 2005 14:27:51 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 07852-05 for ; Mon, 4 Apr 2005 13:27:46 +0000 (GMT) Received: from mopsy2.musc.edu (mopsy2.musc.edu [128.23.34.56]) by svr1.postgresql.org (Postfix) with ESMTP id D52DE52A4F for ; Mon, 4 Apr 2005 14:27:45 +0100 (BST) Received: from revere3.musc.edu (revere3.musc.edu [128.23.203.9]) by mopsy2.musc.edu (8.12.10/8.12.10) with ESMTP id j34DRjG5005417 for ; Mon, 4 Apr 2005 09:27:45 -0400 Received: from cottontail.musc.edu (cottontail.musc.edu [128.23.203.163]) by revere3.musc.edu (8.12.9/8.12.9) with ESMTP id j34DRiDI009651 for ; Mon, 4 Apr 2005 09:27:44 -0400 (EDT) Received: from [128.23.116.83] (bioinfo-admin.muh.musc.edu [128.23.116.83]) (authenticated bits=0) by cottontail.musc.edu (8.12.10/8.12.10) with ESMTP id j34DRdQm011569 (version=TLSv1/SSLv3 cipher=RC4-MD5 bits=128 verify=NOT) for ; Mon, 4 Apr 2005 09:27:44 -0400 Message-ID: <425140BD.3080902@musc.edu> Date: Mon, 04 Apr 2005 09:27:25 -0400 From: Chuming Chen Reply-To: chen@musc.edu Organization: Department of Biostatistics, Bioinformatics and Epidemiology, Medical University of South Carolina User-Agent: Mozilla Thunderbird 0.7.3 (Windows/20040803) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin list Subject: is this normal? Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-MUSC-MailScanner-Information: Please contact postmstr@musc.edu for more information X-MUSC-MailScanner: Found to be clean X-MUSC-MailScanner-SpamCheck: X-MailScanner-From: chen@musc.edu X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200504/46 X-Sequence-Number: 17059 Dear all, I have a postgresql database. "du -ks /var/lib/pgsql/data" gives me the following disk usage 45592808 /var/lib/pgsql/data (about 44G) But after I did a pg_dump, the dump file only has the size of 5.9 G. Thank you for your kind reply and comments. -- Chuming Chen System Administrator NHLBI Proteomics Center Medical University of South Carolina 135 Cannon Street, Suite 303 Charleston SC 29425 Tel: 843-792-1555 (O) Fax: 843-876-1126