Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 0ED792E2D42 for ; Mon, 4 Feb 2008 16:21:29 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 94237-08 for ; Mon, 4 Feb 2008 16:21:10 -0400 (AST) Received: from outmail136059.authsmtp.com (outmail136059.authsmtp.com [62.13.136.59]) by postgresql.org (Postfix) with ESMTP id 448B62E32AC for ; Mon, 4 Feb 2008 16:21:13 -0400 (AST) Received: from outmail128181.authsmtp.net (outmail128181.authsmtp.net [62.13.128.181]) by punt2.authsmtp.com (8.13.8/8.13.8/Kp) with ESMTP id m14KL9AD009798; Mon, 4 Feb 2008 20:21:09 GMT Received: from [192.168.0.3] (85-211-31-42.dyn.gotadsl.co.uk [85.211.31.42]) (authenticated bits=0) by mail.authsmtp.com (8.13.8/8.13.8/Kp) with ESMTP id m14KL8L3046254; Mon, 4 Feb 2008 20:21:09 GMT Subject: Re: Benchmark Data requested From: Simon Riggs To: Greg Smith Cc: pgsql-performance@postgresql.org In-Reply-To: References: <1202150236.4252.521.camel@ebony.site> Content-Type: text/plain Date: Mon, 04 Feb 2008 20:21:56 +0000 Message-Id: <1202156516.4252.580.camel@ebony.site> Mime-Version: 1.0 X-Mailer: Evolution 2.8.2 Content-Transfer-Encoding: 7bit X-Server-Quench: b8bfd531-d35e-11dc-9554-001185d377ca X-AuthRoute: OCdxZQATClZOTQEd DAteCiNZVAwpPBRK HVkIKg5MJUcNSQVJ NksadBtFaAFba1xT HGQLW1xEUl17W2J/ awMfZQBDYEtPQQZr TkxLXVBXCwUmXB0F fWIWLhpycwNEfXo+ ZEdlWj4JVBYsIUN+ Q1MAFmhTeGZhPDMC WUVdcx5UcAJLdhoR aVd4ByJDAzANdhEA MjUdGAoUCH11JSJe QgQEN1FabU8XF3Ym SgkfEC4zEEFt X-Authentic-SMTP: 61633235383639.squirrel.dmpriest.net.uk:787/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: 200802/12 X-Sequence-Number: 28554 On Mon, 2008-02-04 at 15:09 -0500, Greg Smith wrote: > On Mon, 4 Feb 2008, Simon Riggs wrote: > > > Would anybody like to repeat these tests with the latest production > > versions of these databases (i.e. with PGSQL 8.3) > > Do you have any suggestions on how people should run TPC-H? It looked > like a bit of work to sort through how to even start this exercise. The link referred to a few different scale factors, so you could try those. But anything that uses the hardware you have to its full potential is valuable. Everybody's test method is going to be different, whatever I say... -- Simon Riggs 2ndQuadrant http://www.2ndQuadrant.com