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 09:44:51 -0500
Message-ID: <1130337891.2872.8.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?
The absolutely funniest thing about what this guy is saying is that he
seems rather ignorant of the behaviour of innodb tables. They have
another name for the vacuum command there. It's:
ALTER TABLE tbl_name ENGINE=INNODB
Which rebuilds the whole fraggin's table, with an exclusive lock.
and guess what innodb does if you don't run this command every so often?
Can you guess yet? Yep, that's right, it just keeps growing and growing
and growing.
Hell, innodb isn't any better than the original mvcc implementation
postgresql had when vacuums were all full and took exclusive locks.
But at least with PostgreSQL it was a well documented issue, and was
mentioned in the administrative section of the docs, so you knew you had
to do it. It's kind of tucked away in the innodb section of the mysql
docs, and most mysql folks don't even know they need to do it, since
they almost all use myisam table types.
If someone is more worried about postgresql's non-blocking, easily
scheduled vacuuming, but is using myisam tables, and a database that by
default allows numeric overflows to just insert the maximum possible
value, I wouldn't trust them with handling my paycheck with their
fan-boy database.
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: <1130337891.2872.8.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