From: Scott Marlowe <smarlowe@g2switchworks.com>
To: Kenneth Gonsalves <lawgon@thenilgiris.com>
Cc: PostgreSQL SQL <pgsql-sql@postgresql.org>
Subject: Re: why vacuum
Date: Wed, 26 Oct 2005 10:19:40 -0500
Message-ID: <1130339980.2872.12.camel@state.g2switchworks.com> (raw)
In-Reply-To: <200510261015.17623.lawgon@thenilgiris.com>
References: <200510261015.17623.lawgon@thenilgiris.com>
On Tue, 2005-10-25 at 23:45, Kenneth Gonsalves wrote:
> hi,
> i was in a minor flame war with a mysql guy - his major grouse was that
> 'I wouldnt commit mission critical data to a database that needs to be
> vacuumed once a week'. So why does pg need vacuum?
Oh man oh man. After reading the article, I realized he was saying that
he wouldn't trust PostgreSQL to replace Oracle. He apparently wouldn't
trust MySQL to replace oracle either.
But, the next time someone says that slony is a toy add on, and MySQL
has REAL replication, point them to THIS page on the same blog:
http://ebergen.net/wordpress/?p=70
In short, it basically shows that MySQL replication is incredibly
fragile, and not fit for production on any real system. The lack of
system wide transaction support, like postgresql has, makes the problem
he outlines that much worse.
The hoops people will jump through to use their favorite toys...
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: smarlowe@g2switchworks.com, lawgon@thenilgiris.com
Subject: Re: why vacuum
In-Reply-To: <1130339980.2872.12.camel@state.g2switchworks.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox