Re: Re: why the DB file size does not reduce when 'delete'the data in DB?

From: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
To: jamexu <jamexu(at)telekbird(dot)com(dot)cn>
Cc: Mathijs Brands <mathijs(at)ilse(dot)nl>, pgsql-hackers(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org
Subject: Re: Re: why the DB file size does not reduce when 'delete'the data in DB?
Date: 2001-03-07 02:25:27
Message-ID: 3AA59C17.E2FDE23C@alumni.caltech.edu
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...

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Xu Yifeng 2001-03-07 03:10:45 Re[2]: Re: [HACKERS] why the DB file size does not reduce when 'delete'the data in DB?
Previous Message Trond Eivind =?iso-8859-1?q?Glomsr=F8d?= 2001-03-07 01:50:52 Re: How to shoot yourself in the foot: kill -9 postmaster

Browse pgsql-sql by date

  From Date Subject
Next Message Xu Yifeng 2001-03-07 03:10:45 Re[2]: Re: [HACKERS] why the DB file size does not reduce when 'delete'the data in DB?
Previous Message Noodle 2001-03-07 01:30:24 Poor document!!