Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id CC4CA9FC100; Fri, 20 Jul 2007 14:04:01 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 35915-03; Fri, 20 Jul 2007 14:03:58 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from outmail136077.authsmtp.com (outmail136077.authsmtp.com [62.13.136.77]) by postgresql.org (Postfix) with ESMTP id AFE9E9FC0FC; Fri, 20 Jul 2007 14:03:57 -0300 (ADT) Received: from outmail128180.authsmtp.com (outmail128180.authsmtp.com [62.13.128.180]) by punt2.authsmtp.com (8.13.8/8.13.8/Kp) with ESMTP id l6KH3sY7096334; Fri, 20 Jul 2007 18:03:54 +0100 (BST) Received: from [192.168.1.106] (dsl081-245-111.sfo1.dsl.speakeasy.net [64.81.245.111]) (authenticated bits=0) by mail.authsmtp.com (8.13.8/8.13.8/Kp) with ESMTP id l6KH3nxj091566; Fri, 20 Jul 2007 18:03:50 +0100 (BST) Message-ID: <46A0EAE3.7030305@agliodbs.com> Date: Fri, 20 Jul 2007 10:03:31 -0700 From: Josh Berkus User-Agent: Thunderbird 1.5.0.12 (Macintosh/20070509) MIME-Version: 1.0 To: Jim Nasby CC: PostgreSQL List Advocacy , postgresql performance list Subject: Re: [PERFORM] 8.2 -> 8.3 performance numbers References: <73185727-AD4A-4C97-B243-ADD2EE1875B5@decibel.org> In-Reply-To: <73185727-AD4A-4C97-B243-ADD2EE1875B5@decibel.org> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Server-Quench: 3092ea0e-36e3-11dc-867b-001185d377ca X-AuthRoute: OCdyZgscClZXSx8a IioLCC5HRQ8+YBZL BAkGMA9GIUINWEQK c1AAdh1xLVlbHwkB BHYKU15UU1d0WC1z bxRZbBtfZk9QXgRr T0pMQFdNFEs0B2d5 BUBWCBl7dgBAfjBx ZEVrEHNbVUYvJEYo X01SQG4bZGY0O30X VkcKagNUcQJCe0tG bVcsBT1vNG8XDRoV JSEUBRUEdWUZcmwQ FEldawlaWUsREDkm QhkEFjhnG1AATSgp NHQn X-Authentic-SMTP: 61633136333939.squirrel.dmpriest.net.uk:671/Kp X-Report-SPAM: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-Virus-Status: No virus detected - but ensure you scan with your own anti-virus system! X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/120 X-Sequence-Number: 11457 Jim, > Has anyone benchmarked HEAD against 8.2? I'd like some numbers to use in > my OSCon lightning talk. Numbers for both with and without HOT would be > even better (I know we've got HOT-specific benchmarks, but I want > complete 8.2 -> 8.3 numbers). We've done it on TPCE, which is a hard benchmark for PostgreSQL. On that it's +9% without HOT and +13% with HOT. I think SpecJ would show a greater difference, but we're still focussed on benchmarks we can publish (i.e. 8.2.4) right now. --Josh