Skip site navigation (1)Skip section navigation (2)
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>