From: Greg Smith <gsmith@gregsmith.com>
To: Jeffrey Baker <jwbaker@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Strange behavior: pgbench and new Linux kernels
Date: Thu, 17 Apr 2008 14:15:31 -0400 (EDT)
Message-ID: <Pine.GSO.4.64.0804171345350.12303@westnet.com> (raw)
In-Reply-To: <fd145f7d0804171009h7658d3bbqf099b5c0e9235268@mail.gmail.com>
References: <Pine.GSO.4.64.0804170230180.26917@westnet.com>
<fd145f7d0804171009h7658d3bbqf099b5c0e9235268@mail.gmail.com>
On Thu, 17 Apr 2008, Jeffrey Baker wrote:
> This has been discussed recently on linux-kernel.
Excellent pointer, here's direct to the interesting link there:
http://marc.info/?l=linux-kernel&m=120574906013029&w=2
Ingo's test system has 16 cores and dives hard at >32 clients; my 4-core
system has trouble with >8 clients; looks like the same behavior. And it
seems to be fixed in 2.6.25, which just "shipped" literally in the middle
of my testing last night. Had I waited until today to grab a kernel I
probably would have missed the whole thing.
I'll have to re-run to be sure (I just love running a kernel with the
paint still wet) but it looks like the conclusion here is "don't run
PostgreSQL on kernels 2.6.23 or 2.6.24". Good thing I already hated FC8.
If all these kernel developers are using sysbench, we really should get
that thing cleaned up so it runs well with PostgreSQL.
--
* 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, jwbaker@gmail.com
Subject: Re: Strange behavior: pgbench and new Linux kernels
In-Reply-To: <Pine.GSO.4.64.0804171345350.12303@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