postgresql-performance using sysbench

[Claus Guttesen]

> > 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.
>
> There's maybe one additional thing: do you dual-boot Linux and FreeBSD?
> If so, you'll need to set up a separate additional partition for the
> database, instead of benchmarking it with the file systems used by the
> OS, because different areas of the drive(s) have different performance -
> you can verify this with diskinfo -t.

I installed FreeBSD onto a boot-partition (p400i-controller) and used
the external storage (p800) as database-partition (eight 15K rpm
sas-disks in raid 1+0). Same with Ubuntu. When I re-installed FreeBSD
and ubuntu I wiped and formatted the previous partitions. Ubuntu used
ext3 which I guess is default fs.

-- 
regards
Claus

When lenity and cruelty play for a kingdom,
the gentlest gamester is the soonest winner.

Shakespeare