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" <[EMAIL PROTECTED]>
To: "choksi" <[EMAIL PROTECTED]>
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.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
