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 BAC9C5323D for ; Mon, 4 Apr 2005 15:46:22 +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 31251-10 for ; Mon, 4 Apr 2005 14:46:20 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.197]) by svr1.postgresql.org (Postfix) with ESMTP id 77FD652968 for ; Mon, 4 Apr 2005 15:46:19 +0100 (BST) Received: by wproxy.gmail.com with SMTP id 68so1592556wri for ; Mon, 04 Apr 2005 07:46:25 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=E6NhPT9JgPNkSeJGVk4JyNUUfsfvXlagtZmztf4OeWG12a9DbnuG3hMRjeY9RoS2nriWbko3sfGefmVwb/s65ResXspbJEnUOwVCwzXXFRtFQQDsp8bgo6PSWABprUH6nB51iiv4soreTZsvl02Q7jFrhPQXqZUObPYXmWl8SFg= Received: by 10.54.15.21 with SMTP id 21mr370168wro; Mon, 04 Apr 2005 07:46:25 -0700 (PDT) Received: by 10.54.18.43 with HTTP; Mon, 4 Apr 2005 07:46:24 -0700 (PDT) Message-ID: <89bc2a040504040746662b6e62@mail.gmail.com> Date: Mon, 4 Apr 2005 10:46:24 -0400 From: Jason DiCioccio Reply-To: Jason DiCioccio To: chen@musc.edu Subject: Re: is this normal? Cc: pgsql-admin list In-Reply-To: <425140BD.3080902@musc.edu> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit References: <425140BD.3080902@musc.edu> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.342 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200504/49 X-Sequence-Number: 17062 Greetings, On Apr 4, 2005 9:27 AM, Chuming Chen wrote: > 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. I'd guess most of this space is going to your indexes. If you want to drop the space, I'd drop/recreate the indexes and do a VACUUM FULL. Note that these can both be intrusive and should be done during a maintenance period. Regards, -JD-