Re: Is there a meaningful benchmark?

On Thu, Mar 19, 2009 at 4:24 PM, Will Rutherdale (rutherw)
<rutherw(at)cisco(dot)com> wrote:
> Okay, you've given me some useful information.
>
> As the original subject line indicates, I'm open to the idea that no such benchmark exists.
>
> If anyone asks about this stuff, I can just say that performance varies widely by database and application, that Postgres performs well enough against other RDBMSs, that Postgres is known to scale up well and make good use of concurrency, and that I couldn't find any clear benchmark results to back it up.
>
> Of course, if I *did* find any benchmark values then I could have used that to dispel false rumours from the MySQL guys.  However it looks like simple measured indicators aren't easy to come by.

Well, the tweakers benchmarks are a pretty good mysql pgsql
comparison, although getting older now. Apparently mysql has improved
a lot of their concurrency issues that were uncovered in that one.
Pgsql has just continued to get faster.

Google MySQL gotchas for a list of reasons to avoid it. There's a
pgsql gotcha list, it's shorter, and the gotchas are a lot less likely
to induce a case of the vapors.