Received: from localhost (maia-5.hub.org [200.46.204.182])
	by postgresql.org (Postfix) with ESMTP id 382639FA2D2
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Mon, 18 Jun 2007 06:07:10 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024)
	with ESMTP id 10552-02 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Mon, 18 Jun 2007 06:07:01 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
Received: from relay.estp.fr (unknown [213.244.11.228])
	by postgresql.org (Postfix) with ESMTP id EF1169F9C77
	for <pgsql-performance@postgresql.org>;
	Mon, 18 Jun 2007 06:07:04 -0300 (ADT)
Received: from mail.eden.fr (agenda.eyrolles.com [10.2.1.250])
	by relay.estp.fr (Postfix) with ESMTP
	id B80AF7403F; Mon, 18 Jun 2007 11:07:54 +0200 (CEST)
Received: from mail.eden.fr (localhost.localdomain [127.0.0.1])
	by mail.eden.fr (Postfix) with ESMTP id 3A14AA8213;
	Mon, 18 Jun 2007 10:29:56 +0200 (CEST)
Received: from infojmm (unknown [10.2.0.21])
	by mail.eden.fr (Postfix) with SMTP id 97670A820F;
	Mon, 18 Jun 2007 10:29:55 +0200 (CEST)
Message-ID: <075101c7b188$23e46df0$1500020a@eden.fr>
From: "J6M" <j6m@adm.estp.fr>
To: "Francisco Reyes" <lists@stringsutils.com>,
	"choksi" <choksi.dhaval@gmail.com>
Cc: <pgsql-performance@postgresql.org>
References: <1181290934.160823.161630@w5g2000hsg.googlegroups.com>
	<cone.1181927737.662704.53974.5001@35st.simplicato.com>
Subject: Re: Database size
Date: Mon, 18 Jun 2007 10:39:15 +0200
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1";
	reply-type=response
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2900.3028
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
X-Virus-Scanned: ClamAV using ClamSMTP Mon Jun 18 10:29:58 2007 +0200 (CEST)
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.136 tagged_above=0 required=5 tests=AWL=-0.000,
	BAYES_50=0.001, FORGED_RCVD_HELO=0.135
X-Spam-Level: 
X-Archive-Number: 200706/287
X-Sequence-Number: 25320

Hello group,

Moreover a reindex (REINDEX <name of your database> while in pgsql) followed 
by an ANALYZE will claim more space.

Regards
J6M
----- Original Message ----- 
From: "Francisco Reyes" <lists@stringsutils.com>
To: "choksi" <choksi.dhaval@gmail.com>
Cc: <pgsql-performance@postgresql.org>
Sent: Friday, June 15, 2007 7:15 PM
Subject: Re: [PERFORM] Database size


> choksi writes:
>
>> I had a database which uses to hold some 50 Mill records and disk
>> space used was 103 GB. I deleted around 34 Mill records but still the
>> disk size is same. Can some on please shed some light on this.
>
> When records are deleted they are only marked in the database.
> When you run vacuum in the database that space will be marked so new data 
> can use the space.
>
> To lower the space used you need to run "vacuum full".
> That however can take a while and I think it will lock the database for 
> some operations.