Date: Tue, 29 Jan 2008 10:32:54 +0100 From: Ivan Voras <ivoras@freebsd.org> To: freebsd-performance@freebsd.org Subject: Re: postgresql-performance using sysbench Message-ID: <fnmrri$pi4$1@ger.gmane.org> In-Reply-To: <b41c75520801281246q16d305ecue915e66bea6ac5ab@mail.gmail.com> References: <b41c75520801280701x35e628dk90841b55cac77045@mail.gmail.com> <fnl35p$hnj$1@ger.gmane.org> <200801281024.11571.darcyb@commandprompt.com> <b41c75520801281221i5fbb32f3p1e2f3be40a8dfa74@mail.gmail.com> <479E3C5E.1070405@FreeBSD.org> <b41c75520801281246q16d305ecue915e66bea6ac5ab@mail.gmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enig7F31BBEEDDC685A4EC4BA658 Claus Guttesen wrote: > 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. --------------enig7F31BBEEDDC685A4EC4BA658 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHnvLTldnAQVacBcgRAq/eAKC74EcOl2Xs9whdrhauOSxNtx+35wCgobAb gh6afuw0X2ED5kPd7aRGm98= =Mvec -----END PGP SIGNATURE----- --------------enig7F31BBEEDDC685A4EC4BA658--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?fnmrri$pi4$1>