Re: Re: [SQL] Re: why the DB file size does not reduce when 'delete'the data in DB? - Mailing list pgsql-hackers

From yves@mail2.vlaanderen.net
Subject Re: Re: [SQL] Re: why the DB file size does not reduce when 'delete'the data in DB?
Date
Msg-id 20010316022846.A3804@asua2.vlaanderen.net
Whole thread Raw
In response to Re: why the DB file size does not reduce when 'delete' the data in DB?  (The Hermit Hacker <scrappy@hub.org>)
List pgsql-hackers
On Fri, Mar 16, 2001 at 12:01:36AM +0000, Thomas Lockhart wrote:
> > > You are not quite factually correct above, even given your definition of
> > > "bug". PostgreSQL does reuse deleted record space, but requires an
> > > explicit maintenance step to do this.
> > Could you tell us what that maintenance step is? dumping the db and restoring into a fresh one ? :/
> 
> :) No, "VACUUM" is your friend for this. Look in the reference manual
> for details.
> 
>                      - Thomas

I'm having this problem:
I have a database that is 3 megabyte in size (measured using pg_dump). When
i go to the corresponding data directory (eg du -h data/base/mydbase), it
seems the real disk usage is 135 megabyte! Doing a VACUUM doesn't really
change the disk usage.

Also query & updating speed increases when i dump all data and restore
it into a fresh new database.

I'm running postgresql-7.0.2-6 on a Debian potato.

-Yves


pgsql-hackers by date:

Previous
From: Jan Wieck
Date:
Subject: Re: Performance monitor signal handler
Next
From: "Ross J. Reedstrom"
Date:
Subject: Re: Problems with outer joins in 7.1beta5