Date: Mon, 28 Jan 2008 21:46:54 +0100 From: "Claus Guttesen" <kometen@gmail.com> To: "Kris Kennaway" <kris@freebsd.org> Cc: Darcy Buskermolen <darcyb@commandprompt.com>, freebsd-performance@freebsd.org Subject: Re: postgresql-performance using sysbench Message-ID: <b41c75520801281246q16d305ecue915e66bea6ac5ab@mail.gmail.com> In-Reply-To: <479E3C5E.1070405@FreeBSD.org> References: <b41c75520801280701x35e628dk90841b55cac77045@mail.gmail.com> <fnl35p$hnj$1@ger.gmane.org> <200801281024.11571.darcyb@commandprompt.com> <b41c75520801281221i5fbb32f3p1e2f3be40a8dfa74@mail.gmail.com> <479E3C5E.1070405@FreeBSD.org>
next in thread | previous in thread | raw e-mail | index | archive | help
> >>>> 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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?b41c75520801281246q16d305ecue915e66bea6ac5ab>