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 f27ImVx84199 for ; Wed, 7 Mar 2001 13:48:31 -0500 (EST) (envelope-from pgsql-sql-owner@postgresql.org) Received: from myst.fourpalms.org (myst.jpl.nasa.gov [137.78.15.105]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f273OJx18930; Tue, 6 Mar 2001 22:24:19 -0500 (EST) (envelope-from lockhart@alumni.caltech.edu) Received: from alumni.caltech.edu (localhost.localdomain [127.0.0.1]) by myst.fourpalms.org (Postfix) with ESMTP id 5613EC592; Wed, 7 Mar 2001 02:25:28 +0000 (UTC) Message-ID: <3AA59C17.E2FDE23C@alumni.caltech.edu> Date: Wed, 07 Mar 2001 02:25:27 +0000 From: Thomas Lockhart Reply-To: thomas@pgsql.com Organization: PostgreSQL X-Mailer: Mozilla 4.76 [en] (X11; U; Linux 2.2.17-21mdk i686) X-Accept-Language: en MIME-Version: 1.0 To: jamexu Cc: Mathijs Brands , pgsql-hackers@postgresql.org, pgsql-sql@postgresql.org Subject: Re: Re: why the DB file size does not reduce when 'delete'the data in DB? References: <008601c0a44f$0d657b20$cc01a8c0@xyf> <20010307004601.A51050@ilse.nl> <1828207391.20010307111045@telekbird.com.cn> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200103/155 X-Sequence-Number: 1807 > do you really know the problem of PGSQL storage manager? it DOES NOT > reuse deleted record space. it also grows database size when you just > update but not insert record. it is a MS ACCESS like storage manager. > it is a functional bug. there is logic bug, performance bug... imho a designed-in feature can not be called a bug, even if you disagree with its intent or implementation. The term "bug" should be reserved for code which does not behave as designed. You are not quite factually correct above, even given your definition of "bug". PostgreSQL does reuse deleted record space, but requires an explicit maintenance step to do this. We have continuing discussions on how to evolve the performance and behavior of PostgreSQL, and you can check the archives on these past discussions. Regards. - Thomas