postgresql-performance using sysbench

[Ivan Voras]

On 31/01/2008, Niki Denev <ndenev at icdsoft.com> wrote:
> On Jan 31, 2008 10:16 PM, Ivan Voras <ivoras at 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