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

• Re: [HACKERS] why the DB file size does not reduce when 'delete' the data in DB? at 2001-03-02 12:04:45 from The Hermit Hacker

Responses

• Re: [HACKERS] why the DB file size does not reduce when 'delete'the data in DB? at 2001-03-04 03:05:29 from The Hermit Hacker
• Re: why the DB file size does not reduce when 'delete'the data in DB? at 2001-03-04 07:15:18 from xuyifeng
• Re: Re: [HACKERS] why the DB file size does not reduce when 'delete'the data in DB? at 2001-03-06 23:46:01 from Mathijs Brands

pgsql-hackers by date

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

pgsql-sql by date

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