Date: Thu, 31 Jan 2008 23:03:14 +0100 From: "Ivan Voras" <ivoras@freebsd.org> To: "Niki Denev" <ndenev@icdsoft.com> Cc: freebsd-performance@freebsd.org Subject: Re: postgresql-performance using sysbench Message-ID: <9bbcef730801311403r45c54036v36b97450d0c37a65@mail.gmail.com> In-Reply-To: <2e77fc10801311242n12c5b2bcseaa2b717f95c21b5@mail.gmail.com> References: <b41c75520801280701x35e628dk90841b55cac77045@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> <2e77fc10801311242n12c5b2bcseaa2b717f95c21b5@mail.gmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
On 31/01/2008, Niki Denev <ndenev@icdsoft.com> wrote: > 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 Ok, under these circumstances+gjournal it's maybe possible to get numbers that low. I am testing operations on small files so my whole configuration is: set size 4096 65536 set read 8192 set write 8192 set number 10000 set transactions 40000 set subdirectories 1000
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?9bbcef730801311403r45c54036v36b97450d0c37a65>