From owner-freebsd-performance@FreeBSD.ORG Tue Mar 11 16:10:36 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 EB217106566B for ; Tue, 11 Mar 2008 16:10:36 +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 5A5C88FC16 for ; Tue, 11 Mar 2008 16:10:36 +0000 (UTC) (envelope-from gofp-freebsd-performance@m.gmane.org) Received: from list by ciao.gmane.org with local (Exim 4.43) id 1JZ73e-0007Q6-S7 for freebsd-performance@freebsd.org; Tue, 11 Mar 2008 16:10:30 +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, 11 Mar 2008 16:10:30 +0000 Received: from ivoras by lara.cc.fer.hr with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Tue, 11 Mar 2008 16:10:30 +0000 X-Injected-Via-Gmane: http://gmane.org/ To: freebsd-performance@freebsd.org From: Ivan Voras Date: Tue, 11 Mar 2008 17:14:40 +0100 Lines: 78 Message-ID: References: <571396.91912.qm@web50512.mail.re2.yahoo.com> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enig2980F56084A3056FC398C300" 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: <571396.91912.qm@web50512.mail.re2.yahoo.com> X-Enigmail-Version: 0.95.0 Sender: news Subject: Re: pgbench results 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, 11 Mar 2008 16:10:37 -0000 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enig2980F56084A3056FC398C300 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable http://www.kaltenbrunner.cc/blog/index.php?/archives/21-guid.html alan bryan wrote: > Here's mine for a somewhat similar setup. =20 > FreeBSD 7.0 PostgreSQL 8.3 > 2x Intel Xeon 2.33GHZ quad cores (8 cores total), 8GB > RAM, 250GB RAID 10 (4x WD Raptor 10K drives). >=20 > Non-default settings:=20 >=20 > =20 > max_connections =3D 200=20 > shared_buffers =3D 1900MB > wal_buffers =3D 1024kB > checkpoint_segments =3D 192 =20 > checkpoint_timeout =3D 30min=20 >=20 > createdb testdb > pgbench -i -s 100 testdb >=20 > # pgbench -c 100 -t 100000 testdb > starting vacuum...end. > transaction type: TPC-B (sort of) > scaling factor: 100 > number of clients: 100 > number of transactions per client: 100000 > number of transactions actually processed: > 10000000/10000000 > tps =3D 1650.806584 (including connections establishing) > tps =3D 1650.905036 (excluding connections establishing) >=20 > So, not as high as his numbers but then I've got less > RAM, one less drive spindle in my array (2 vs. 3 in > performance for the raid 10 setup), SATA vs. SCSI, > he's got 512MB of controller cache vs my 128MB. 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=3D1900 MB, and I "only" get this: tps =3D 2834.026175 (including connections establishing) tps =3D 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=3Doff, I get: tps =3D 2886.980477 (including connections establishing) tps =3D 2891.776081 (excluding connections establishing) --------------enig2980F56084A3056FC398C300 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) iD8DBQFH1q/wldnAQVacBcgRAniVAJwJSqrKPUshKrhhG1wXhG4QkmCEtACg03ZN IkdfVNWM5rbFP+k5XZXEmUY= =kKJZ -----END PGP SIGNATURE----- --------------enig2980F56084A3056FC398C300--