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
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
