On 5/23/07, Harpreet Dhaliwal <[EMAIL PROTECTED]> 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. ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
