X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 8CE11540EC for ; Fri, 15 Apr 2005 18:02:51 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 60622-07 for ; Fri, 15 Apr 2005 21:02:41 +0000 (GMT) Received: from window.monsterlabs.com (window.monsterlabs.com [216.183.105.176]) by svr1.postgresql.org (Postfix) with SMTP id 58EB2540D2 for ; Fri, 15 Apr 2005 18:02:29 -0300 (ADT) Received: (qmail 32586 invoked from network); 15 Apr 2005 21:02:30 -0000 Received: from w080.z064003242.bna-tn.dsl.cnc.net (HELO ?192.168.1.22?) (64.3.242.80) by 0 with SMTP; 15 Apr 2005 21:02:30 -0000 Mime-Version: 1.0 (Apple Message framework v619.2) Content-Transfer-Encoding: quoted-printable Message-Id: <2784476415a96bb0912ebca41edb3d84@sitening.com> Content-Type: text/plain; charset=WINDOWS-1252; format=flowed To: PgSQL - Performance From: Thomas F.O'Connell Subject: pgbench Comparison of 7.4.7 to 8.0.2 Date: Fri, 15 Apr 2005 16:02:29 -0500 X-Mailer: Apple Mail (2.619.2) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200504/365 X-Sequence-Number: 11762 I'm in the fortunate position of having a newly built database server=20 that's pre-production. I'm about to run it through the ringer with some=20= simulations of business data and logic, but I wanted to post the=20 results of some preliminary pgbench marking. http://www.sitening.com/pgbench.html To me, it looks like basic transactional performance is modestly=20 improved at 8.0 across a variety of metrics. I think this bodes well=20 for more realistic loads, but I'll be curious to see the results of=20 some of the simulations. I've still got a little bit of preparatory time with this box, so I can=20= continue to do some experimentation. I'd be curious to see whether these numbers meet developer expectations=20= and to see whether the developer and user community have insight into=20 other pgbench options that would be useful to see. Thanks! -tfo -- Thomas F. O'Connell Co-Founder, Information Architect Sitening, LLC Strategic Open Source: Open Your i=99 http://www.sitening.com/ 110 30th Avenue North, Suite 6 Nashville, TN 37203-6320 615-260-0005=