From: Greg Smith <gsmith@gregsmith.com>
To: pgsql-performance@postgresql.org
Subject: Re: Strange behavior: pgbench and new Linux kernels
Date: Thu, 17 Apr 2008 23:25:07 -0400 (EDT)
Message-ID: <Pine.GSO.4.64.0804172318290.10047@westnet.com> (raw)
In-Reply-To: <alpine.DEB.1.10.0804171740250.18186@asgard>
References: <Pine.GSO.4.64.0804170230180.26917@westnet.com>
<fd145f7d0804171009h7658d3bbqf099b5c0e9235268@mail.gmail.com>
<Pine.LNX.4.64.0804171840180.20402@aragorn.flymine.org>
<Pine.GSO.4.64.0804172002010.15803@westnet.com>
<alpine.DEB.1.10.0804171740250.18186@asgard>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: gsmith@gregsmith.com
Subject: Re: Strange behavior: pgbench and new Linux kernels
In-Reply-To: <Pine.GSO.4.64.0804172318290.10047@westnet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox