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 f22Djix10182 for ; Fri, 2 Mar 2001 08:45:44 -0500 (EST) (envelope-from pgsql-sql-owner@postgresql.org) Received: from edison.gits.net.th (edison.gits.net.th [164.115.2.130]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f22CZUx00319; Fri, 2 Mar 2001 07:35:30 -0500 (EST) (envelope-from jaruwan@gits.net.th) Received: from wan ([203.150.154.109]) by edison.gits.net.th (8.10.1/8.10.1) with SMTP id f22CZSl00219; Fri, 2 Mar 2001 19:35:28 +0700 (GMT) Message-ID: <000f01c0a315$ff81a0e0$6d9a96cb@ntl> From: "Jaruwan Laongmal" To: , Subject: why the DB file size does not reduce when 'delete' the data in DB? Date: Fri, 2 Mar 2001 19:40:42 +0700 MIME-Version: 1.0 Content-Type: text/plain; charset="windows-874" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200103/22 X-Sequence-Number: 1664 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? I am looking forward to your response. Thank you very much for any help. - Jaruwan