Re: postgresql-performance using sysbench

On Monday 28 January 2008 09:25:13 Ivan Voras wrote:
Claus Guttesen wrote:
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.

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. No tuning can help here.



--
Darcy Buskermolen
Command Prompt, Inc.
+1.503.667.4564 X 102
http://www.commandprompt.com/
PostgreSQL solutions since 1997
_______________________________________________
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: FreeBSD + MySQL or PostgreSQL
    ... >> Which one, MySQL or PostgreSQL, is most compatible, stable, etc. ... > set up and maintain under FreeBSD. ... Currently I'm using MySQL on a production FreeBSD 5.2.1 box. ...
    (freebsd-questions)
  • Re: Adaptec 3210S, 4.9-STABLE, corruption when disk fails
    ... >>you can use the 'raidutil' program under FreeBSD to upload ... >>the firmware to the controller. ... > The problem is definitely not in postgresql. ... as possible would be to deliberately fail all remaining old disk drives, ...
    (freebsd-stable)
  • Re: Postgresql Autovacuum how?
    ... I have FreeBSD 6.1 and PostgreSQL 8.1.3 installed. ... I've created a .pgpass file in /root (which is read only by ... The autovacuum script was packaged for FreeBSD, so I assume this is a ...
    (freebsd-questions)
  • securing postgresql on fbsd
    ... I've installed postgresql on freebsd 4.10-rel. ... to connect ONLY to 127.0.0.1 port 5432. ... So it looks like I wasn't building the tunnel correctly. ...
    (freebsd-questions)
  • Re: Regression testing (was Re: Performance issue)
    ... Does FreeBSD have any facilities setup for peoople wishing to work on ... Something akin to http://pgfoundry.org ... Several of us have been using pgFoundry as a means to ... work on things that will eventually go into PostgreSQL itself, ...
    (freebsd-performance)