From: Arjen van der Meijden <acmmailing@tweakers.net>
To: Jim C. Nasby <jim@nasby.net>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: yoav x <yoav112003@yahoo.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: PostgreSQL and sql-bench
Date: Fri, 22 Sep 2006 00:26:15 +0200
Message-ID: <45131187.3050800@tweakers.net> (raw)
In-Reply-To: <20060921214913.GV28987@nasby.net>
References: <20060921145244.13005.qmail@web35813.mail.mud.yahoo.com>
<829.1158851565@sss.pgh.pa.us>
<20060921214913.GV28987@nasby.net>
On 21-9-2006 23:49 Jim C. Nasby wrote:
> Even with fsync = off, there's still a non-trivial amount of overhead
> brought on by MVCC that's missing in myisam. If you don't care about
> concurrency or ACIDity, but performance is critical (the case that the
> MySQL benchmark favors), then PostgreSQL probably isn't for you.
That depends on the required scalability (both in number of cpu's and in
number of concurrent clients). In our benchmarks MySQL is beaten by
PostgreSQL in a read-mostly environment with queries that are designed
for MySQL, but slightly adjusted to work on PostgreSQL (for MySQL 5.0
and 5.1, about the same adjustments where needed).
But for very low amounts of concurrent users, MySQL outperforms PostgreSQL.
Have a look here:
http://tweakers.net/reviews/646/10
and here:
http://tweakers.net/reviews/638/4
As you can see both MySQL 5.0 and 4.1 start much higher for a few
clients, but when you add more clients or more cpu's, MySQL scales less
good and even starts dropping performance and soon is far behind
compared to PostgreSQL.
So for a web-application, PostgreSQL may be much better, since generally
the only situation where you need maximum performance, is when you have
to service a lot of concurrent visitors.
But if you benchmark only with a single thread or do benchmarks that are
no where near a real-life environment, it may show very different
results of course.
Best regards,
Arjen van der Meijden
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: acmmailing@tweakers.net, jim@nasby.net, tgl@sss.pgh.pa.us, yoav112003@yahoo.com
Subject: Re: PostgreSQL and sql-bench
In-Reply-To: <45131187.3050800@tweakers.net>
* 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