Date: Thu, 31 Jan 2008 22:42:06 +0200 From: "Niki Denev" <ndenev@icdsoft.com> To: "Ivan Voras" <ivoras@freebsd.org> Cc: freebsd-performance@freebsd.org Subject: Re: postgresql-performance using sysbench Message-ID: <2e77fc10801311242n12c5b2bcseaa2b717f95c21b5@mail.gmail.com> In-Reply-To: <fntaaj$dp8$1@ger.gmane.org> References: <b41c75520801280701x35e628dk90841b55cac77045@mail.gmail.com> <b41c75520801281246q16d305ecue915e66bea6ac5ab@mail.gmail.com> <fnmrri$pi4$1@ger.gmane.org> <b41c75520801290146g4e6e2c17oe2fc432245253ba7@mail.gmail.com> <47A043FD.9090607@FreeBSD.org> <fnpjvo$n8i$1@ger.gmane.org> <47A0CD11.802@FreeBSD.org> <9bbcef730801301157n25684018y3d43bfdd0301a8dd@mail.gmail.com> <2e77fc10801310826v2fabb5g594840241784fc7@mail.gmail.com> <fntaaj$dp8$1@ger.gmane.org>
next in thread | previous in thread | raw e-mail | index | archive | help
On Jan 31, 2008 10:16 PM, Ivan Voras <ivoras@freebsd.org> wrote: > Niki Denev wrote: > > > HZ=1000 > > Time: > > 239 seconds total > > 122 seconds of transactions (4 per second) > > > What do you think? > > This is a very low result :) I don't know your machine or the parameters > you used with postmark but even FreeBSD on two striped 7.5 kRPM drives > can achieve ~~ 110 tps (so ~~ 50 for a single drive). In the same > circumstances and with the right file system - reiserfs in this case - > Linux can achieve close to 900 tps (170 tps with ext3). This is the kind > of difference I am talking about. A change of 4 tps to 6 tps is not > generally useful. > > What settings are you using for postmark? I ran postmark with default settings, and only changed "size" to "4096 4096000", so it could create files varying in size from 4K to 3.9M The machine is dualcore core2duo and has two 10Krpm scsi disks in geom_mirror and geom_journal on top of them. I guess that this may be because of geom_journal performance penalty, having to write everything two times. Ubench too shows no significant difference, although its not using disk subsystem at all. HZ=250 Ubench CPU: 322604 Ubench MEM: 152835 -------------------- Ubench AVG: 237719 HZ=1000 Ubench CPU: 321800 Ubench MEM: 152807 -------------------- Ubench AVG: 237303 Maybe i'll try also "bonnie++"
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?2e77fc10801311242n12c5b2bcseaa2b717f95c21b5>