From: | Jim Nasby <decibel(at)decibel(dot)org> |
---|---|
To: | Tom Allison <tom(at)tacocat(dot)net> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Benchmarking PostgreSQL against others on Windows? |
Date: | 2006-11-28 01:17:24 |
Message-ID: | E8811791-C6F4-4602-92A5-C656D95E8CD8@decibel.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Nov 27, 2006, at 5:24 AM, Tom Allison wrote:
> Basically it comes down to this:
> simple SELECT statements: mysql almost always wins.
> Everything else is mixed.
> There are a few cases where postgresql does really poorly but the
> operations are rare daily activity.
> INSERT/UPDATE/DELETE postgresql "generally" does better.
>
> The problem with the tests is that these are typically done with
> single users at a time and they don't exercise any of the other
> benefits that postgresql offers. But I would suggest you set up
> two versions of some aspect of your working environment: one in
> postgres and on in MySQL and run them for a few weeks using mock
> client scripts to perform different actions.
Actually, the folks over at http://tweakers.net recently benchmarked
MySQL and PostgreSQL with their website code. IIRC, this is mostly
"simple selects", yet PostgreSQL clearly outperformed MySQL once you
had a few concurrent connections happening.
My experience is that the only places you'll readily see MySQL
outperform PostgreSQL is when you're only using a single connection,
and probably not with complex queries.
Of course, the first rule of benchmarking is to use your own
application.
--
Jim Nasby jim(at)nasby(dot)net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
From | Date | Subject | |
---|---|---|---|
Next Message | Jim Nasby | 2006-11-28 01:19:11 | Re: Which installer for Postgres on Windows? |
Previous Message | Jim Nasby | 2006-11-28 01:12:27 | Re: Benchmarking PostgreSQL against others on Windows? |