Date: Wed, 12 Mar 2008 13:10:23 +1300 From: Mark Kirkwood <markir@paradise.net.nz> To: Ivan Voras <ivoras@freebsd.org> Cc: freebsd-performance@freebsd.org Subject: Re: pgbench results Message-ID: <47D71F6F.2090600@paradise.net.nz> In-Reply-To: <fr6at8$tpm$1@ger.gmane.org> References: <fr33lg$tdu$1@ger.gmane.org> <571396.91912.qm@web50512.mail.re2.yahoo.com> <fr6at8$tpm$1@ger.gmane.org>
index | next in thread | previous in thread | raw e-mail
Ivan Voras wrote: > > The thing is - I *do* have a similar setup here: HP DL370 G5, 2x4-core > 1.86 GHz, 4 GB RAM, 6 drives in RAID10, 512 MB cache (can pull > 200 > MB/s off the array), with all settings like in the posted link except > shared_buffer=1900 MB, and I "only" get this: > > tps = 2834.026175 (including connections establishing) > tps = 2839.080739 (excluding connections establishing) > > This is still far bellow ~~ 4500 trans/s from the link and I wonder if > my results are within what I should be getting. The benchmark in the > link above was done with faster CPUs (but I'm not CPU bound - at least > 30% idle), but with 3 times the memory and I'm guessing more memory > would help here, but I'm not sure. > > What's strange is that toggling synchronous_commit doesn't have a > significant effect on performance (it does increase CPU idle time). With > synchronous_commit=off, I get: > > tps = 2886.980477 (including connections establishing) > tps = 2891.776081 (excluding connections establishing) > > The article refers to a controller with a battery backed write cache - that could easily explain the difference if you do not have one (he's paying nothing for fsync wheres you are). regards Markhome | help
Want to link to this message? Use this
URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?47D71F6F.2090600>