Postgres Pro
Downloads
Home   >   mailing lists

Re: Re[2]: [SQL] Re: why the DB file size does not reduce when 'delete'the data in DB? - Mailing list pgsql-hackers

From Tatsuo Ishii
Subject Re: Re[2]: [SQL] Re: why the DB file size does not reduce when 'delete'the data in DB?
Date
Msg-id 20010307123307K.t-ishii@sra.co.jp
Whole thread Raw
In response to Re[2]: [SQL] Re: why the DB file size does not reduce when 'delete'the data in DB?  (Xu Yifeng <jamexu@telekbird.com.cn>)
List pgsql-hackers
Tree view 
> 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

pgsql-hackers by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: [SQL] Re: why the DB file size does not reduce when 'delete'the data in DB?
Next
From: "Hiroshi Inoue"
Date:
Subject: RE: Proposed WAL changes