Re: [HACKERS] why the DB file size does not reduce when 'delete'the data in DB?

On Sun, 4 Mar 2001, xuyifeng wrote:

>
> ----- Original Message -----
> From: The Hermit Hacker <scrappy(at)hub(dot)org>
> To: Jaruwan Laongmal <jaruwan(at)gits(dot)net(dot)th>
> Cc: <pgsql-hackers(at)postgresql(dot)org>; <pgsql-sql(at)postgresql(dot)org>
> Sent: Friday, March 02, 2001 8:04 PM
> Subject: Re: [HACKERS] why the DB file size does not reduce when 'delete'the data in DB?
>
>
> > On Fri, 2 Mar 2001, Jaruwan Laongmal wrote:
> >
> > > I had deleted a very large number of records out of my SQL table in order to
> > > decrease the harddisk space. But after I use command 'ls -l
> > > /usr/local/pgsql/data/base/', it is found that the size of concerning files
> > > do not reduce due to the effect of 'delete' SQL command. What should I do
> > > if I would like to decrease the harddisk space?
> >
> > VACUUM
> >
> >
>
> could anyone remove this nasty bug in 7.2? this is already a big pain
> and is the reason why am I still using MySQL in my product server.
> another nasty thing is it does not allow me to reference table in
> another database. sigh.

Its actually not considered a *bug*, but it was a feature that was part of
an older feature that was removed. Vadim has plans for implementing an
OverWriting Storage Manager, but scheduale of it is uncertain ... could be
for v7.2 ...