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 f22FxXx38986 for ; Fri, 2 Mar 2001 10:59:33 -0500 (EST) (envelope-from pgsql-sql-owner@postgresql.org) Received: from golem.fourpalms.org (www.fourpalms.org [64.3.68.148]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f22DUfx07909; Fri, 2 Mar 2001 08:30:41 -0500 (EST) (envelope-from lockhart@alumni.caltech.edu) Received: from alumni.caltech.edu (localhost.localdomain [127.0.0.1]) by golem.fourpalms.org (Postfix) with ESMTP id 63008FEB7; Fri, 2 Mar 2001 13:30:38 +0000 (UTC) Message-ID: <3A9FA07E.AB3A6DB6@alumni.caltech.edu> Date: Fri, 02 Mar 2001 13:30:38 +0000 From: Thomas Lockhart Reply-To: lockhart@fourpalms.org Organization: Yes X-Mailer: Mozilla 4.75 [en] (X11; U; Linux 2.2.17-21mdksmp i686) X-Accept-Language: en 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=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200103/27 X-Sequence-Number: 1671 > 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 "vacuum" from SQL or "vacuumdb" from the command line. Tables will be reduced in size, though currently indices are not. - Thomas