| From: | Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp> |
|---|---|
| To: | jamexu(at)telekbird(dot)com(dot)cn |
| Cc: | mathijs(at)ilse(dot)nl, pgsql-hackers(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Re[2]: Re: [HACKERS] why the DB file size does not reduce when 'delete'the data in DB? |
| Date: | 2001-03-07 03:33:07 |
| Message-ID: | 20010307123307K.t-ishii@sra.co.jp |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-sql |
> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hiroshi Inoue | 2001-03-07 04:38:36 | RE: How to shoot yourself in the foot: kill -9 postmaster |
| Previous Message | The Hermit Hacker | 2001-03-07 03:14:42 | Re[2]: Re: [HACKERS] why the DB file size does not reduce when 'delete'the data in DB? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Keith Gray | 2001-03-07 04:40:17 | Query Limitations |
| Previous Message | The Hermit Hacker | 2001-03-07 03:14:42 | Re[2]: Re: [HACKERS] why the DB file size does not reduce when 'delete'the data in DB? |