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 3BD1753329 for ; Mon, 4 Apr 2005 15:52:00 +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 33623-09 for ; Mon, 4 Apr 2005 14:51:52 +0000 (GMT) Received: from mopsy2.musc.edu (mopsy2.musc.edu [128.23.34.56]) by svr1.postgresql.org (Postfix) with ESMTP id 375B052A33 for ; Mon, 4 Apr 2005 15:51:51 +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 j34EpoG5006884; Mon, 4 Apr 2005 10:51:51 -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 j34EpoDI006500; Mon, 4 Apr 2005 10:51:50 -0400 (EDT) Received: from [128.23.116.246] (grid.muh.musc.edu [128.23.116.246]) (authenticated bits=0) by cottontail.musc.edu (8.12.10/8.12.10) with ESMTP id j34EpjQm021356 (version=TLSv1/SSLv3 cipher=RC4-MD5 bits=128 verify=NOT); Mon, 4 Apr 2005 10:51:50 -0400 Message-ID: <42515482.7080701@musc.edu> Date: Mon, 04 Apr 2005 10:51:46 -0400 From: Chuming Chen User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.6) Gecko/20050328 Fedora/1.7.6-1.2.5 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Lee Wu Cc: pgsql-admin list Subject: Re: is this normal? References: In-Reply-To: Content-Type: text/plain; charset=us-ascii; 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/50 X-Sequence-Number: 17063 Lee Wu wrote: >How do you do dump? With compressness? > > I used "pg_dump -o dbname" >Do you have a lot of dead tuples/index entries? > > > > How can I check this and remove them? >-----Original Message----- >From: pgsql-admin-owner@postgresql.org >[mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Chuming Chen >Sent: Monday, April 04, 2005 7:27 AM >To: pgsql-admin list >Subject: [ADMIN] is this normal? > >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