Re: Vacuum DB in Postgres Vs similar concept in other RDBMS - Mailing list pgsql-general

From Alexander Staubo
Subject Re: Vacuum DB in Postgres Vs similar concept in other RDBMS
Date
Msg-id 88daf38c0705231059t6d6cddbcnbc563ceb294fd722@mail.gmail.com
Whole thread Raw
In response to Vacuum DB in Postgres Vs similar concept in other RDBMS  ("Harpreet Dhaliwal" <harpreet.dhaliwal01@gmail.com>)
Responses Remove query results from cache
List pgsql-general
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.

pgsql-general by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: [Re] Re: [Re] Re: Winsock error 10035 while trying to upgrade from 8.0 to 8.2
Next
From: Donald Laurine
Date:
Subject: Performance