Re: postgresql-performance using sysbench

Ubuntu 7.10:

grep "transactions:" sysbench-clients-24|sort
transactions: 10000 (2354.49 per sec.)
transactions: 10001 (2126.28 per sec.)
transactions: 10001 (2215.52 per sec.)
transactions: 10001 (2236.03 per sec.)

FreeBSD 7.0 stable as of Jan. 28'th:

grep "transactions:" sysbench-clients-24|sort
transactions: 10001 (1600.36 per sec.)
transactions: 10002 (1963.95 per sec.)
transactions: 10005 (1973.17 per sec.)

In other runs FreeBSD also seems to trail Ubuntu. Are there any knobs
I could try on FreeBSD?

I think the excellent results Kris got with FreeBSD were significantly
helped by patching postgresql to remove setproctitle().

You don;t need to patch postgresql for that, all you need to do is turn that
off.

update_process_title = off in postgresql.conf and then restart the daemon.

I found the setting and set it to off but no real difference in performance.

from the sysbench line I see this is OLTP benchmark which should mean
a lot of write transactions, and I've consistently seen much better file
system write performance on Linux than on FreeBSD. No tuning can help here.

Yes, that is correct. I wanted to conduct a r/w test. But if it's down
to the fs itself I will just leave it atm. I will probably deploy the
server on FreeBSD anyway since we probably won't reach that many
writes in the foreseable future and FreeBSD is what I do best.

Will zfs be able to achieve better performance? I guess that ufs2 will
remain more or less in the state it is in now.

--
regards
Claus

When lenity and cruelty play for a kingdom,
the gentlest gamester is the soonest winner.

Shakespeare
_______________________________________________
freebsd-performance@xxxxxxxxxxx mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-performance
To unsubscribe, send any mail to "freebsd-performance-unsubscribe@xxxxxxxxxxx"

Relevant Pages

  • Re: postgresql-performance using sysbench
    ... In other runs FreeBSD also seems to trail Ubuntu. ... Are there any knobs ... a lot of write transactions, and I've consistently seen much better file ...
    (freebsd-performance)
  • Re: postgresql-performance using sysbench
    ... In other runs FreeBSD also seems to trail Ubuntu. ... Are there any knobs ... Other than that, from the sysbench line I see this is OLTP benchmark which should mean a lot of write transactions, and I've consistently seen much better file system write performance on Linux than on FreeBSD. ...
    (freebsd-performance)
  • HEADS UP: NOFOO -> NO_FOO
    ... conversion of various build knobs has just been done in HEAD. ... while still providing the support ... broken ports, and then the support for old ... need to support more than just FreeBSD 6.0-CURRENT. ...
    (freebsd-current)
  • Re: postgresql-performance using sysbench
    ... On Monday 28 January 2008 09:25:13 Ivan Voras wrote: ... In other runs FreeBSD also seems to trail Ubuntu. ... helped by patching postgresql to remove setproctitle. ...
    (freebsd-performance)