Re: Vacuum DB in Postgres Vs similar concept in other RDBMS

On 5/23/07, Harpreet Dhaliwal <harpreet.dhaliwal01@gmail.com> wrote:
> I was wondering if Vacuum DB concept in Postgres is really novel and there's
> no concept like this in other RDBMS like oracle or sql server.
> If at all other RDBMS have such a concept implemented, how good or bad it is
> as compared to postgres's vacuum db concept.

As we told you the last time you asked
(http://archives.postgresql.org/pgsql-general/2007-05/msg00074.php),
the concept of vacuuming is not unique to PostgreSQL by far. It is an
inherent facet of MVCC.

Other databases that implement MVCC, or implement an MVCC-like system
that requires garbage collection, include Oracle, SQLite, Firebird and
its parent project InterBase. Wikipedia has a decent article on MVCC:

  http://en.wikipedia.org/wiki/Multiversion_concurrency_control

Alexander.