Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 80AA66347E0 for ; Tue, 31 Mar 2009 20:35:57 -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 50779-01 for ; Tue, 31 Mar 2009 20:35:55 -0300 (ADT) Received: from mx1.hub.org (mx1.hub.org [200.46.208.106]) by mail.postgresql.org (Postfix) with ESMTP id 1B6A26347F3 for ; Tue, 31 Mar 2009 20:35:56 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from westnet.com (westnet.com [216.187.52.2]) by mx1.hub.org (Postfix) with ESMTP id BE231125A9D3 for ; Tue, 31 Mar 2009 20:35:55 -0300 (ADT) Received: from westnet.com (localhost [127.0.0.1]) by westnet.com (8.14.0/8.14.0) with ESMTP id n2VNZrpE023233; Tue, 31 Mar 2009 19:35:53 -0400 (EDT) Received: from localhost (gsmith@localhost) by westnet.com (8.14.0/8.13.2/Submit) with ESMTP id n2VNZrPh023229; Tue, 31 Mar 2009 19:35:53 -0400 (EDT) X-Authentication-Warning: westnet.com: gsmith owned process doing -bs Date: Tue, 31 Mar 2009 19:35:53 -0400 (EDT) From: Greg Smith X-X-Sender: gsmith@westnet.com To: Kevin Grittner cc: pgsql-performance@postgresql.org Subject: Re: Strange behavior: pgbench and new Linux kernels In-Reply-To: <49D2466F.EE98.0025.0@wicourts.gov> Message-ID: References: <49D2466F.EE98.0025.0@wicourts.gov> User-Agent: Alpine 2.01 (GSO 1184 2008-12-16) MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed 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: 200903/445 X-Sequence-Number: 33367 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: > >> It seems I have a lot of work ahead of me here >> to nail down and report what's going on here. > > 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 never got any confirmation that the patches that came out of my discussions with the kernel developers were ever merged. I'm in the middle of a bunch of pgbench tests this week, and one of the things I planned to try was seeing if the behavior has changed in 2.6.28 or 2.6.29. I'm speaking about pgbench at the PostgreSQL East conference this weekend and will have an update by then (along with a new toolchain for automating large quantities of pgbench tests). -- * Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD