Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id D7873632E41 for ; Sat, 4 Apr 2009 15:55:13 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 67151-01 for ; Sat, 4 Apr 2009 15:55:12 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outmail136054.authsmtp.net (outmail136054.authsmtp.net [62.13.136.54]) by mail.postgresql.org (Postfix) with ESMTP id 759D0632902 for ; Sat, 4 Apr 2009 15:55:12 -0300 (ADT) Received: from mail-c193.authsmtp.com (mail-c193.authsmtp.com [62.13.128.118]) by punt9.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id n34It7ch058337; Sat, 4 Apr 2009 19:55:07 +0100 (BST) Received: from Sidney-Stratton.local (adsl-63-195-55-98.dsl.snfc21.pacbell.net [63.195.55.98]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id n34It5SK014017; Sat, 4 Apr 2009 19:55:06 +0100 (BST) Message-ID: <49D7AD08.5080202@agliodbs.com> Date: Sat, 04 Apr 2009 11:55:04 -0700 From: Josh Berkus Organization: Aglio Database Solutions User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US; rv:1.9.1b3pre) Gecko/20090223 Thunderbird/3.0b2 MIME-Version: 1.0 To: Greg Smith CC: Kevin Grittner , pgsql-performance@postgresql.org Subject: Re: Strange behavior: pgbench and new Linux kernels References: <49D2466F.EE98.0025.0@wicourts.gov> In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Server-Quench: 1d49a19c-214a-11de-8a51-002264978518 X-AuthRoute: OCdyZgscClZXSx8a IioLCC5HRQ8+YBZL BAkGMA9GIUINWEQK c1ACch16KEdbHwkB CnYKUl5RVVdxXi1z aBRQZABDZ09QVg11 Uk1LR01SWltrBWVF A31lUhh2dwRBNn91 bE8sXyRfVRV7fBVg QE9QRHAHZDM1dWhO VUFFdwNWcgVOdxhN b1F3GhFYa3VsBg8C MSgJGgV5BilFISJa T0kHIFIbX0cMBGx0 Xx8IEDMkHQUMQSl7 KRE5YnodGlsBekY/ K10sXUlw X-Authentic-SMTP: 61633136333939.pelican.dmpriest.net.uk:1378/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-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200904/100 X-Sequence-Number: 33467 On 4/4/09 9:07 AM, Greg Smith wrote: > On Tue, 31 Mar 2009, Kevin Grittner wrote: > >>>>> On Thu, Apr 17, 2008 at 7:26 PM, Greg Smith wrote: >> >>> On this benchmark 2.6.25 is the worst kernel yet: >> >> I don't remember seeing a follow-up on this issue from last year. >> Are there still any particular kernels to avoid based on this? > > I just discovered something really fascinating here. The problem is > strictly limited to when you're connecting via Unix-domain sockets; use > TCP/IP instead, and it goes away. Have you sent this to any Linux kernel engineers? My experience is that they're fairly responsive to this sort of thing. --Josh