From: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> |
---|---|
To: | "Pascal Cohen" <pcohen(at)wimba(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: H2 database |
Date: | 2009-01-06 09:27:29 |
Message-ID: | dcc563d10901060127q5c15d12dsf68b64f1d1b360a9@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, Jan 6, 2009 at 1:16 AM, Pascal Cohen <pcohen(at)wimba(dot)com> wrote:
> Hello and best wishes for this new year.
> I have a question concerning the H2 DB.
> http://www.h2database.com/html/main.html
> I've read (on their site) that they got better perfs than PG or MySQL in any
> case (embedded in a Java application and even as a standalone server).
> Tests seem a bit "light" with a single thread benchmarking the DB but the
> results seem anyway interesting.
So, in other words, it's not really that interesting. :) How well a
db runs with a single thread really doesn't mean a lot unless you're
only using it for single user embedded or batch processing. I'd like
to see a simple pgbench style (i.e. mixed reads and writes with
transactions) benchmark with 5, 10, 50, 100 users, etc... That would
tell you something interesting. Since they haven't published a
benchmark with > 1 user, I'm willing to bet that the performance with
> 1 users is not so good, and gets worse as you add users.
http://tweakers.net/reviews/649/8/database-test-sun-ultrasparc-t1-vs-punt-amd-opteron-pagina-8.html
Now that is an interesting benchmark. Notice how MySQL is a good
20-30% faster with one user? More importantly see what it does with
many users, and how it behaves as the number of users increases.
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2009-01-06 09:29:00 | Re: [HACKERS] ERROR: failed to find conversion function from "unknown" to text |
Previous Message | Gurjeet Singh | 2009-01-06 09:24:42 | Re: [HACKERS] ERROR: failed to find conversion function from "unknown" to text |