Re: Perf regression in 2.6.32 (Ubuntu 10.04 LTS)

On 09/13/2010 06:43 PM, Greg Smith wrote:
> 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.

yeah the read-only part works quite well(the other ones not so much) and
it was much faster than pgbench in older pg release - I have not looked
yet if the new threaded in 9.0 implementation fixes that issue.

Stefan