From: Christian Fowler <spider@viovio.com>
To: Evilio del Rio <edelrio@cmima.csic.es>
Cc: postgresql performance list <pgsql-performance@postgresql.org>
Subject: Re: Postgres vs. MySQL
Date: Wed, 24 Nov 2004 09:57:52 -0500 (EST)
Message-ID: <Pine.LNX.4.61.0411240908400.22359@leda.steelsun.com> (raw)
In-Reply-To: <1101302058.338.74.camel@haddock.cmima.csic.es>
References: <1101302058.338.74.camel@haddock.cmima.csic.es>
As for performance, lots of others will probably volunteer tips and
techniques. In my experience, properly written and tuned applications will
show only minor speed differences. I have seen several open-source apps
that "support postgres" but are not well tested on it. Query optimization
can cause orders of magnitude performance differences. It sounds maybe
dspam is in this bucket?
>
> Please, could anyone explain me this difference?
> Is Postgres that bad?
> Is MySQL that good?
> Am I the only one to have observed this behavior?
I made a little chart about these about a year ago:
http://www.tikipro.org/wiki/index.php?page=DatabaseComparison
If speed is what you need, and data integrity / safety is not, then MySQL
may be a good choice. (Aggregate statistics tables and other such
calculated denormalizations).
IMHO, if all you need is dpsam running *now*, then I'd say MySQL might be
good choice. If you ever need to run a DB application where data integrity
is mission critical, then postgres is the top of my list.
[ \ /
[ >X< Christian Fowler | spider AT viovio.com
[ / \ http://www.viovio.com | http://www.tikipro.org
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-performance@postgresql.org
Cc: spider@viovio.com, edelrio@cmima.csic.es
Subject: Re: Postgres vs. MySQL
In-Reply-To: <Pine.LNX.4.61.0411240908400.22359@leda.steelsun.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