Date: Wed, 27 Aug 2003 12:50:05 -0400 (EDT) From: Robert Watson <rwatson@freebsd.org> To: Bill Moran <wmoran@potentialtech.com> Cc: freebsd-performance@freebsd.org Subject: Re: Performance tests I did with FreeBSD, Linux and PostgreSQL Message-ID: <Pine.NEB.3.96L.1030827124628.25213H-100000@fledge.watson.org> In-Reply-To: <3F4C143D.7000909@potentialtech.com>
next in thread | previous in thread | raw e-mail | index | archive | help
On Tue, 26 Aug 2003, Bill Moran wrote: > Like all benchmarks, I doubt these are perfect (or even close) examples > of real-world use. > > However, in the hopes that they will be useful for improving FreeBSD, I > present them to the community. > > http://www.potentialtech.com/wmoran/postgresql.php > > Intelligent comments are welcome. I'd have to chime in here with two recommendations: (1) Try 4.8-STABLE (2) Try 5.1-CURRENT With a distinct preference for (1) before (2). Some parts of -CURRENT have gotten faster, others have gotten temporarily slower (new locks in place without Giant coming off them yet, which adds overhead). I'd also check your block sizes for interaction with Postgres and see if different block and fragment sizes help/hurt. It could be that postgres would benefit from different tuning parameters on FreeBSD, especially with newer UFS file systems. Robert N M Watson FreeBSD Core Team, TrustedBSD Projects robert@fledge.watson.org Network Associates Laboratories
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?Pine.NEB.3.96L.1030827124628.25213H-100000>