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.

I wouldn't deploy zfs on a prod. db-server so this is just to hear if
some had tried zfs (with compression enabled).


I went through this in detail in a thread on -stable recently (Subject:
Performance!). Rather than me going over all of this again, can you
please read that thread in detail and get back to me once you have
applied all of the discussion there to your case.

I had (allready) saved the thread in my mail-account so I could look
it up before I started testing. :-) So I compiled postgresql with the
option WITH_THREADSAFE=true and used sysbench with --pgsql-host="" .
As pointed out by Ivan my test also involved r/w whereas the thread
you (probably) mention at
http://groups.google.com/group/mailing.freebsd.stable/browse_thread/thread/e224cd4f76e9ec2d
is a read-only test.

I forgot to mention in my first post that I'm using ULE. The p800
controller has a (factory set) 25/75 read/write cache ratio.

--
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: Backup solution suggestions
    ... your best bet when it comes to backups like what you ... a server with the specifications you want, and run FreeBSD on it. ... and you only have one person to turn to: the vendor. ... Once all of our systems are running RELENG_7, I plan on utilising ZFS ...
    (freebsd-stable)
  • Re: Backup solution suggestions
    ... a server with the specifications you want, and run FreeBSD on it. ... The NAS/ backup box would be located on an 100MBit/1000MBit unmetered link. ... Once all of our systems are running RELENG_7, I plan on utilising ZFS ... fashion (6 days of incrementals, 1 day of full) and do "zfs send ...
    (freebsd-stable)
  • On ZFS and 64/32 dual-booting.
    ... Since there are still reasons to dual boot between i386 and amd64 on FreeBSD ... I briefly considered making a zfs root, but there are several reasons not: ... I've always followed the tradition of mounting foreign filesystems as ...
    (freebsd-hackers)
  • "New" user with a possible ZFS problem
    ... I've been running FreeBSD for about a year or so on my web/mail server, which I only have remote access to. ... After getting a taste of ZFS while trying out OpenSolaris Indiana under VMware, I decided to give FreeBSD's ZFS implementation a try. ... Actually before installing FreeBSD I tried a native OpenSolaris Indiana install briefly, but ended up deciding it's new package system wasn't quite ready for prime time yet. ... then eventually I experienced my first hang. ...
    (freebsd-questions)
  • nfs on zfs panic
    ... I'm playing with zfs on vmware on FreeBSD current (world and kernel of today with GENERIC kernel). ... GNU gdb 6.1.1 ...
    (freebsd-current)