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