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 f22Fxux39040 for ; Fri, 2 Mar 2001 10:59:56 -0500 (EST) (envelope-from pgsql-sql-owner@postgresql.org) Received: from taru.tm.ee (taru.tm.ee [194.204.62.23]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f22Ewfx25498; Fri, 2 Mar 2001 09:58:41 -0500 (EST) (envelope-from hannu@tm.ee) Received: from tm.ee (localhost.localdomain [127.0.0.1]) by taru.tm.ee (Postfix) with ESMTP id 9A68CE087; Fri, 2 Mar 2001 17:03:05 +0200 (CAT) Message-ID: <3A9FB629.4080601@tm.ee> Date: Fri, 02 Mar 2001 17:03:05 +0200 From: Hannu Krosing User-Agent: Mozilla/5.0 (X11; U; Linux 2.4.1-22mdk i686; en-US; 0.7) Gecko/20010112 X-Accept-Language: et, en, ru, cs MIME-Version: 1.0 To: Jaruwan Laongmal Cc: pgsql-hackers@postgresql.org, pgsql-sql@postgresql.org Subject: Re: [HACKERS] why the DB file size does not reduce when 'delete' the data in DB? References: <000f01c0a315$ff81a0e0$6d9a96cb@ntl> Content-Type: text/plain; charset=TIS-620; format=flowed Content-Transfer-Encoding: 7bit X-Archive-Number: 200103/25 X-Sequence-Number: 1667 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? Run the command VACUUM; This will do the actual removal of deleted records. DELETE just marks them as deleted > I am looking forward to your response. Thank you very much for any help. > - > Jaruwan