Re: Strange behavior: pgbench and new Linux kernels

From: Greg Smith <gsmith(at)gregsmith(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Strange behavior: pgbench and new Linux kernels
Date: 2008-04-18 03:25:07
Message-ID: Pine.GSO.4.64.0804172318290.10047@westnet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Thu, 17 Apr 2008, david(at)lang(dot)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(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Craig Ringer 2008-04-18 03:41:17 Re: SQL Function Slowness, 8.3.0
Previous Message david 2008-04-18 00:41:39 Re: Strange behavior: pgbench and new Linux kernels