Moreover a reindex (REINDEX <name of your database> while in pgsql) followed
by an ANALYZE will claim more space.
----- Original Message -----
From: "Francisco Reyes" <lists(at)stringsutils(dot)com>
To: "choksi" <choksi(dot)dhaval(at)gmail(dot)com>
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.
In response to
pgsql-performance by date
|Next:||From: Sabin Coanda||Date: 2007-06-18 13:09:05|
|Subject: Re: Parsing VACUUM VERBOSE|
|Previous:||From: Tom Lane||Date: 2007-06-16 15:07:08|
|Subject: Re: determining maxsize for character varying |