[mweilguni a sime.com: [HACKERS] MySQL vs. Postgres - congratulations to the postgres team]
andrea gelmini
andrea.gelmini a lugbs.linux.it
Mar 10 Apr 2001 08:57:23 UTC
giro visto che ho avuto una discussione a riguardo recentemente
con alcuni luggari...
ciao,
andrea
----- Forwarded message from Mario Weilguni <mweilguni a sime.com> -----
From: Mario Weilguni <mweilguni a sime.com>
Reply-To: mweilguni a sime.com
To: pgsql-hackers a postgresql.org
Subject: [HACKERS] MySQL vs. Postgres - congratulations to the postgres team
Date: Mon, 9 Apr 2001 20:26:54 +0200
X-Mailer: KMail [version 1.2]
DISCLAIMER: don't take this as MySQL flaming (it isn't) or personally, this
are just my observations on an application, not a benchmark.
Today I tried a quite simple, mostly write database (HTTP logging).
* Postgres peaked at 709 inserts/sec (committed after 3 seconds or 100
inserts, whichever comes first)
* MySQL peaked at 735 inserts/sec (no transactions)
However, MySQL completly choked over when trying to query something usefull
out of the database while the inserts are running (at full speed). Postgres
worked like a charm. The only real advantage of mysql was a simple "select
count(1) from logs", which mysql answered immidiatly,while postgres did a
full table scan.
For querying the DB, postgres won, my queries ran about 12% faster in
Postgres than MySQL.
Given the fact that the "one-user" case was MySQL's real advantage up to now,
Postgres 7.1 will be an important milestone.
--
===================================================
Mario Weilguni KPNQwest Austria GmbH
Senior Engineer Web Solutions Nikolaiplatz 4
tel: +43-316-813824 8020 graz, austria
fax: +43-316-813824-26 http://www.kpnqwest.at
e-mail: mario.weilguni a kpnqwest.com
===================================================
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo a postgresql.org
----- End forwarded message -----
Maggiori informazioni sulla lista
Lug
|