From: Arjen van der Meijden <acmmailing@tweakers.net>
To: Qingqing Zhou <zhouqq@cs.toronto.edu>
Cc: pgsql-performance@postgresql.org
Subject: Re: Pgsql (and mysql) benchmark on T2000/Solaris and some
Date: Tue, 16 May 2006 12:47:59 +0200
Message-ID: <4469ADDF.1010405@tweakers.net> (raw)
In-Reply-To: <e4c84c$t7t$1@news.hub.org>
References: <44699C6C.80302@tweakers.net>
<e4c84c$t7t$1@news.hub.org>
Qingqing Zhou wrote:
> "Arjen van der Meijden" <acmmailing@tweakers.net> wrote
> Some sort of web query behavior is quite optimized in MySQL. For example,
> the query below is runing very fast due to the query result cache
> implementation in MySQL.
>
> Loop N times
> SELECT * FROM A WHERE i = 1;
> End loop.
Yeah, I know. But our queries get random parameters though for
identifiers and the like, so its not just a few queries getting executed
a lot of times, there are. In a run for which I just logged all queries,
almost 42k distinct queries executed from 128k in total (it may actually
be more random than real life).
Besides that, they are not so extremely simple queries as your example.
Most join at least two tables, while the rest often joins three to five.
But I agree, MySQL has a big advantage with its query result cache. That
makes the current performance of postgresql even more impressive in this
situation, since the query cache of the 4.1.x run was enabled as well.
> IMHO, without knowing the exact queries you sent, these logs are not very
> useful :-(. I would suggest you compare the queries in pair and then post
> their dtrace/timing results here (just like the previous Firebird vs.
> PostgreSQL comparison did).
Well, I'm bound to some privacy and copyright laws, but I'll see if I
can show some example plans of at least the top few queries later today
(the top two is resp 27% and 21% of the total time).
But those top queries aren't the only ones run during the benchmarks or
in the production environment, nor are they run exclusively at any given
time. So the overall load-picture should be usefull too, shouldn't it?
Best regards,
Arjen
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, zhouqq@cs.toronto.edu
Subject: Re: Pgsql (and mysql) benchmark on T2000/Solaris and some
In-Reply-To: <4469ADDF.1010405@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