Re: Perf regression in 2.6.32 (Ubuntu 10.04 LTS)

Thom Brown wrote:
> I thought sysbench was designed for MySQL benchmarks. How new is the
> PostgreSQL driver? Is it stable yet?
>

It's been out there for years; the FreeBSD 7.0 development used it
extensively on MySQL and PostgreSQL to track kernel performance on both
databases back in 2007:
http://people.freebsd.org/~kris/scaling/7.0%20Preview.pdf

I don't think "stable" applies here just based on code age though, given
how infrequent updates to the sysbench code are and how little QA is put
into them. They pushed out two updates in 2009, 0.4.11 and 0.4.12, but
all they did for me was break basic compilation on multiple platforms.
I still use 0.4.10 as the last version that seems to work without
makefile surgery on both RedHat and Ubuntu.

The last time I tried it, the read-only OLTP implementation worked fine,
but the one that wrote instead was prone to deadlocks in PostgreSQL.

--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
greg(at)2ndQuadrant(dot)com www.2ndQuadrant.us