From: J6M <j6m@adm.estp.fr>
To: Francisco Reyes <lists@stringsutils.com>
To: choksi <choksi.dhaval@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Database size
Date: Mon, 18 Jun 2007 10:39:15 +0200
Message-ID: <075101c7b188$23e46df0$1500020a@eden.fr> (raw)
References: <1181290934.160823.161630@w5g2000hsg.googlegroups.com>
<cone.1181927737.662704.53974.5001@35st.simplicato.com>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: j6m@adm.estp.fr, lists@stringsutils.com, choksi.dhaval@gmail.com
Subject: Re: Database size
In-Reply-To: <075101c7b188$23e46df0$1500020a@eden.fr>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox