From: Evilio del Rio <edelrio@cmima.csic.es>
To: dspam-users@networkdweebs.com
Cc: pgsql-performance@postgresql.org
Subject: Postgres vs. MySQL
Date: Wed, 24 Nov 2004 14:14:18 +0100
Message-ID: <1101302058.338.74.camel@haddock.cmima.csic.es> (raw)
Hi,
I have installed the dspam filter
(http://www.nuclearelephant.com/projects/dspam) on our mail server
(RedHat 7.3 Linux with sendmail 8.13 and procmail). I have ~300 users
with a quite low traffic of 4000 messages/day. So it's a quite common
platform/environment, nothing spectacular.
First time(s) I tried the Postgres interface that was already installed
for other applications. Whenever I begin to train and/or filter
messages throug dspam the performance is incredibly bad. First messages
are ok but soon the filter time begins to increase to about 30 seconds
or more!
...so I looked for some optimization both for the linux kernel and the
postgres server. Nothing has work for me. I always have the same
behavior. For isolation purposes I started using another server just to
hold the dspam database and nothing else. No matter what I do: postgres
gets slower and slower with each new message fed or filtered.
Several strategies have failed: newest RPMs from postgresql.org,
pg_autovacuum, etc.
I finally tried the MySQL driver.
I have started using this tool right now for dspam, so I am a newcomer
in MySQL.
The result: after some preparation in configuring some parameters for
mysqld (with the "QuickStart" Guide from mysql.com) all works fine!
It's incredible! the same servers, the same messages, the same dspam
compilation (well each one with the corresponding
--with-storage-driver=*sql_drv). Postgres is getting worst than
30s/message and MySQL process the same in less than a second.
I can surrender the Postgres server by just corpus-feeding one single
short message to each user (it takes hours to process 300 users!).
On the other hand, MySQL only takes a few minutes to process the same
batch.
I do not want to make flame over Postgres (I have always prefered it for
its capabilities) but I am absolutely impressed by MySQL (I have seen
the light!)
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?
TIA.
Cheers,
----------------------------------------------------------------
Evilio Jose del Rio Silvan Centre Mediterrani d'Investigacions
edelrio@cmima.csic.es Marines i Ambientals
"Microsoft sells you Windows, Linux gives you the whole house" - Anonymous
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: edelrio@cmima.csic.es, dspam-users@networkdweebs.com
Subject: Re: Postgres vs. MySQL
In-Reply-To: <1101302058.338.74.camel@haddock.cmima.csic.es>
* 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