Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f26FIxx13064 for ; Tue, 6 Mar 2001 10:18:59 -0500 (EST) (envelope-from pgsql-sql-owner@postgresql.org) Received: from www.stocke.com ([202.101.165.60]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f2420Yx66045; Sat, 3 Mar 2001 21:00:34 -0500 (EST) (envelope-from jamexu@telekbird.com.cn) Received: from xyf ([61.164.150.69]) by www.stocke.com (8.9.3/8.9.3) with SMTP id KAA10432; Sun, 4 Mar 2001 10:01:02 +0800 Message-ID: <008601c0a44f$0d657b20$cc01a8c0@xyf> From: "xuyifeng" To: , References: Subject: Re: [HACKERS] why the DB file size does not reduce when 'delete'the data in DB? Date: Sun, 4 Mar 2001 10:01:37 +0800 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2615.200 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200 Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from base64 to 8bit by mail.postgresql.org id f2420b066049 X-Archive-Number: 200103/101 X-Sequence-Number: 1751 ----- Original Message ----- From: The Hermit Hacker To: Jaruwan Laongmal Cc: ; 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