postgresql-performance using sysbench

Kris Kennaway kris at FreeBSD.org
Wed Jan 30 01:31:43 PST 2008


Claus Guttesen wrote:
>>> 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.

Write performance is something that we are working on, expect to hear 
about progress over the coming weeks/months.

Kris


More information about the freebsd-performance mailing list