Skip site navigation (1) Skip section navigation (2)

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

From: The Hermit Hacker <scrappy(at)hub(dot)org>
To: xuyifeng <jamexu(at)telekbird(dot)com(dot)cn>
Cc: <pgsql-hackers(at)postgresql(dot)org>, <pgsql-sql(at)postgresql(dot)org>
Subject: Re: [HACKERS] why the DB file size does not reduce when 'delete'the data in DB?
Date: 2001-03-04 03:05:29
Message-ID: Pine.BSF.4.33.0103032304290.33622-100000@mobile.hub.org (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-sql
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 ...



In response to

pgsql-hackers by date

Next:From: xuyifengDate: 2001-03-04 07:15:18
Subject: Re: why the DB file size does not reduce when 'delete'the data in DB?
Previous:From: xuyifengDate: 2001-03-04 02:01:37
Subject: Re: [HACKERS] why the DB file size does not reduce when 'delete'the data in DB?

pgsql-sql by date

Next:From: Gerald GutierrezDate: 2001-03-04 04:32:37
Subject: Passing table names to PL/PGSQL for SELECT/UPDATE/INSERT
Previous:From: xuyifengDate: 2001-03-04 02:01:37
Subject: Re: [HACKERS] why the DB file size does not reduce when 'delete'the data in DB?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group