Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id BB7CB2E0032 for ; Fri, 18 Apr 2008 00:25:31 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 02939-07 for ; Fri, 18 Apr 2008 00:25:15 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from westnet.com (westnet.com [216.187.52.2]) by developer.postgresql.org (Postfix) with ESMTP id 029352E0054 for ; Fri, 18 Apr 2008 00:25:08 -0300 (ADT) Received: from westnet.com (localhost [127.0.0.1]) by westnet.com (8.14.0/8.14.0) with ESMTP id m3I3P86W013297 for ; Thu, 17 Apr 2008 23:25:08 -0400 (EDT) Received: from localhost (gsmith@localhost) by westnet.com (8.14.0/8.13.2/Submit) with ESMTP id m3I3P7Ta013294 for ; Thu, 17 Apr 2008 23:25:07 -0400 (EDT) X-Authentication-Warning: westnet.com: gsmith owned process doing -bs Date: Thu, 17 Apr 2008 23:25:07 -0400 (EDT) From: Greg Smith X-X-Sender: gsmith@westnet.com To: pgsql-performance@postgresql.org Subject: Re: Strange behavior: pgbench and new Linux kernels In-Reply-To: Message-ID: References: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/257 X-Sequence-Number: 29750 On Thu, 17 Apr 2008, david@lang.hm wrote: > report this to the kernel list so that they know, and be ready to test fixes. Don't worry, I'm on that. I'm already having enough problems with database performance under Linux, if they start killing results on the easy benchmarks I'll really be in trouble. > if the only people providing test results are MySQL people, how would > they know there is a problem? The thing I was alluding to is that both FreeBSD and Linux kernel developers are now doing all their PostgreSQL tests with sysbench, a MySQL tool with rudimentary PostgreSQL support bolted on (badly). I think rather than complain about it someone (and I fear this will be me) needs to just fix that so it works well. It really handy for people to have something they can get familiar with that runs against both databases in a way they can be compared fairly. Right now PG beats MySQL scalability despite that on read tests, the big problems with PG+sysbench are when you try to write with it. -- * Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD