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: "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 (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-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

pgsql-hackers by date

Next:From: The Hermit HackerDate: 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 LaneDate: 2001-03-03 19:06:55
Subject: Re: [CORE] WAL & RC1 status

pgsql-sql by date

Next:From: The Hermit HackerDate: 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 HardingDate: 2001-03-03 17:38:44
Subject: Re: Temp Tables & Connection Pooling

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