Received: from sraigw.sra.co.jp (sraigw.sra.co.jp [202.32.10.2]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f273XZx48751; Tue, 6 Mar 2001 22:33:35 -0500 (EST) (envelope-from t-ishii@sra.co.jp) Received: from sranhk.sra.co.jp (sranhk [133.137.36.134]) by sraigw.sra.co.jp (8.8.7/3.7W-sraigw) with ESMTP id MAA11237; Wed, 7 Mar 2001 12:33:29 +0900 (JST) Received: from localhost (IDENT:t-ishii@srapc1474 [133.137.13.54]) by sranhk.sra.co.jp (8.9.3/3.7W-srambox) with ESMTP id MAA25462; Wed, 7 Mar 2001 12:33:22 +0900 To: jamexu@telekbird.com.cn Cc: mathijs@ilse.nl, pgsql-hackers@postgresql.org, pgsql-sql@postgresql.org Subject: Re: Re[2]: Re: [HACKERS] why the DB file size does not reduce when 'delete'the data in DB? In-Reply-To: <1828207391.20010307111045@telekbird.com.cn> References: <008601c0a44f$0d657b20$cc01a8c0@xyf> <20010307004601.A51050@ilse.nl> <1828207391.20010307111045@telekbird.com.cn> X-Mailer: Mew version 1.94.2 on Emacs 20.7 / Mule 4.1 =?iso-2022-jp?B?KBskQjAqGyhCKQ==?= Mime-Version: 1.0 Content-Type: Text/Plain; charset=us-ascii Content-Transfer-Encoding: 7bit Message-Id: <20010307123307K.t-ishii@sra.co.jp> Date: Wed, 07 Mar 2001 12:33:07 +0900 From: Tatsuo Ishii X-Dispatcher: imput version 20000228(IM140) Lines: 9 X-Archive-Number: 200103/131 X-Sequence-Number: 1783 > 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... It's not a bug but a feature invented by Michael Stonebraker. Write to him why do you think that is a bug:-) -- Tatsuo Ishii