Re: MySQL vs. PostgreSQL - Mailing list pgsql-general

From Curt Sampson
Subject Re: MySQL vs. PostgreSQL
Date
Msg-id Pine.NEB.4.44.0207131908540.454-100000@angelic.cynic.net
Whole thread Raw
In response to Re: MySQL vs. PostgreSQL  (Elaine Lindelef <eel@cognitivity.com>)
Responses Re: MySQL vs. PostgreSQL  (Steve Lane <slane@fmpro.com>)
List pgsql-general
On Fri, 12 Jul 2002, Elaine Lindelef wrote:

> Yes, there are points to quibble on, but overall, I thought it was a
> decent article that exposed people to the idea of using PostgreSQL.

Well, yeah, but it's really time to kill, properly, this idea that
postgres is always slower than mysql. I'm reasonably convinced that
under fairly heavy OLTP loads with some large queries going, MySQL would
grind to a halt at loads much less than postgres can handle.

The only area I know of where MySQL is noticably faster is when
dealing with large amounts of data in tables with very short rows;
MySQL has much less row overhead, so of course it's faster. Though
people are working on reducing postgres' row overhead as well,
which will help....

cjs
--
Curt Sampson  <cjs@cynic.net>   +81 90 7737 2974   http://www.netbsd.org
    Don't you know, in this new Dark Age, we're all light.  --XTC


pgsql-general by date:

Previous
From: Alex Rice
Date:
Subject: Objective-C wrappers for LibPq?
Next
From: Curt Sampson
Date:
Subject: Re: PostgreSQL in mission-critical system