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

From: "xuyifeng" <jamexu(at)telekbird(dot)com(dot)cn>
To: <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 02:01:37
Message-ID: 008601c0a44f$0d657b20$cc01a8c0@xyf
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-sql


----- 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.

Regards,
XuYifeng

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message The Hermit Hacker 2001-03-04 03:05:29 Re: [HACKERS] why the DB file size does not reduce when 'delete'the data in DB?
Previous Message Tom Lane 2001-03-03 19:06:55 Re: [CORE] WAL & RC1 status

Browse pgsql-sql by date

  From Date Subject
Next Message The Hermit Hacker 2001-03-04 03:05:29 Re: [HACKERS] why the DB file size does not reduce when 'delete'the data in DB?
Previous Message Ian Harding 2001-03-03 17:38:44 Re: Temp Tables & Connection Pooling