From owner-freebsd-performance@FreeBSD.ORG Tue Jan 29 09:32:52 2008 Return-Path: Delivered-To: freebsd-performance@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id EB7B716A41A for ; Tue, 29 Jan 2008 09:32:52 +0000 (UTC) (envelope-from gofp-freebsd-performance@m.gmane.org) Received: from ciao.gmane.org (main.gmane.org [80.91.229.2]) by mx1.freebsd.org (Postfix) with ESMTP id 7133C13C43E for ; Tue, 29 Jan 2008 09:32:52 +0000 (UTC) (envelope-from gofp-freebsd-performance@m.gmane.org) Received: from list by ciao.gmane.org with local (Exim 4.43) id 1JJmph-00073U-VZ for freebsd-performance@freebsd.org; Tue, 29 Jan 2008 09:32:45 +0000 Received: from lara.cc.fer.hr ([161.53.72.113]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Tue, 29 Jan 2008 09:32:45 +0000 Received: from ivoras by lara.cc.fer.hr with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Tue, 29 Jan 2008 09:32:45 +0000 X-Injected-Via-Gmane: http://gmane.org/ To: freebsd-performance@freebsd.org From: Ivan Voras Date: Tue, 29 Jan 2008 10:32:54 +0100 Lines: 39 Message-ID: References: <200801281024.11571.darcyb@commandprompt.com> <479E3C5E.1070405@FreeBSD.org> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enig7F31BBEEDDC685A4EC4BA658" X-Complaints-To: usenet@ger.gmane.org X-Gmane-NNTP-Posting-Host: lara.cc.fer.hr User-Agent: Thunderbird 2.0.0.6 (X11/20071022) In-Reply-To: X-Enigmail-Version: 0.95.0 Sender: news Subject: Re: postgresql-performance using sysbench X-BeenThere: freebsd-performance@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Performance/tuning List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 29 Jan 2008 09:32:53 -0000 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--