Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id ACDA09FB5A7 for ; Sat, 2 Jun 2007 16:45:29 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 54787-03 for ; Sat, 2 Jun 2007 16:45:26 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from outmail136049.authsmtp.co.uk (outmail136049.authsmtp.co.uk [62.13.136.49]) by postgresql.org (Postfix) with ESMTP id 35B409FB591 for ; Sat, 2 Jun 2007 16:45:26 -0300 (ADT) Received: from outmail128182.authsmtp.co.uk (outmail128182.authsmtp.co.uk [62.13.128.182]) by punt3.authsmtp.com (8.13.8/8.13.8/Kp) with ESMTP id l52JjNrL056042; Sat, 2 Jun 2007 20:45:23 +0100 (BST) Received: from [192.168.2.2] (adsl-63-195-55-98.dsl.snfc21.pacbell.net [63.195.55.98]) (authenticated bits=0) by mail.authsmtp.com (8.13.8/8.13.8/Kp) with ESMTP id l52JjJCS069396; Sat, 2 Jun 2007 20:45:20 +0100 (BST) Message-ID: <4661C8A1.2030206@agliodbs.com> Date: Sat, 02 Jun 2007 12:44:33 -0700 From: Josh Berkus User-Agent: Thunderbird 1.5.0.12 (Macintosh/20070509) MIME-Version: 1.0 To: PFC CC: Tom Lane , Arjen van der Meijden , pgsql-performance@postgresql.org Subject: Re: Postgres Benchmark Results References: <46507A40.505@tweakers.net> <2438.1179681998@sss.pgh.pa.us> In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Server-Quench: cc8d5722-1141-11dc-a443-001185d377ca X-AuthRoute: OCdyZgscClZXSx8a IioLCC5HRQ8+YBZL BAkGMA9GIUINWEQN c1ACdB1xLVtbHwkB BHYJW15QVVdzWC1z aBRQZABDZ09QVg11 Uk1LR01SWlltA2Zb fG19Uh97dAxANn9w YEMsDSNTCEF9d0Rg Q09QFHAHZDMzdTEb VENFdwNVcQtPKhxC bQMuGhFYa3VsBg8C MSgJGgV5BTJENCtP TxpFB18USkYOFyQ/ DyoPBigrAVZt 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: 200706/18 X-Sequence-Number: 25051 PFC, Thanks for doing those graphs. They've been used by Simon &Heikki, and now me, to show our main issue with PostgreSQL performance: consistency. That is, our median response time beats MySQL and even Oracle, but our bottom 10% does not, and is in fact intolerably bad. If you want us to credit you by your real name, let us know what it is. Thanks! --Josh Berkus