postgresql-performance using sysbench

[Ivan Voras]

> I had (allready) saved the thread in my mail-account so I could look
> it up before I started testing. :-) So I compiled postgresql with the
> option WITH_THREADSAFE=3Dtrue and used sysbench with --pgsql-host=3D"" =
=2E
> As pointed out by Ivan my test also involved r/w whereas the thread
> you (probably) mention at
> http://groups.google.com/group/mailing.freebsd.stable/browse_thread/thr=
ead/e224cd4f76e9ec2d
> is a read-only test.
>=20
> 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.


-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: OpenPGP digital signature
Url : http://lists.freebsd.org/pipermail/freebsd-performance/attachments/20080129/6038bd62/signature.pgp