From: Greg Smith <gsmith@gregsmith.com>
To: Anton Petrusevich <casus@casus.us>
Cc: lkml <linux-kernel@vger.kernel.org>
Subject: Re: PostgreSQL pgbench performance regression in 2.6.23+
Date: Fri, 23 May 2008 14:46:13 -0400 (EDT) [thread overview]
Message-ID: <Pine.GSO.4.64.0805231418140.3708@westnet.com> (raw)
In-Reply-To: <200805231326.44247.casus@casus.us>
On Fri, 23 May 2008, Anton Petrusevich wrote:
> Excuse me for interrupting you, but am I getting this right: to run
> effectively PostgreSQL with an active web app on the server a "system
> administrator Joe" has to know about batch scheduling?
That's not true. The problem here is specifically with the pgbench
program, which is a simple benchmarking tool included with PostgreSQL.
pgbench already had known scalability problems due to its inefficient
design and the new scheduler really doesn't play well with it by default.
It's the pgbench program that needs the batch scheduling, not the database
processes.
pgbench is certainly not representative of web application performance,
and it wouldn't be the first time there was some OS tweaking required to
get good results from such an artificial benchmark.
--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD
next prev parent reply other threads:[~2008-05-23 18:46 UTC|newest]
Thread overview: 22+ messages / expand[flat|nested] mbox.gz Atom feed top
2008-05-23 11:26 Anton Petrusevich
2008-05-23 18:46 ` Greg Smith [this message]
-- strict thread matches above, loose matches on Subject: below --
2008-05-21 17:34 Greg Smith
2008-05-22 7:10 ` Mike Galbraith
2008-05-22 8:28 ` Dhaval Giani
2008-05-22 9:05 ` Mike Galbraith
2008-05-22 10:34 ` Mike Galbraith
2008-05-22 11:25 ` Mike Galbraith
2008-05-22 11:44 ` Peter Zijlstra
2008-05-22 12:09 ` Mike Galbraith
2008-05-22 12:24 ` Peter Zijlstra
2008-05-22 13:16 ` Mike Galbraith
2008-05-23 7:13 ` Greg Smith
2008-05-23 10:00 ` Mike Galbraith
2008-05-23 10:10 ` Ingo Molnar
2008-05-23 10:15 ` Mike Galbraith
2008-05-23 23:18 ` Greg Smith
2008-05-23 23:46 ` Mike Galbraith
2008-05-24 8:08 ` Mike Galbraith
2008-05-27 0:28 ` Greg Smith
2008-05-23 13:05 ` Mike Galbraith
2008-05-23 13:35 ` Mike Galbraith
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=Pine.GSO.4.64.0805231418140.3708@westnet.com \
--to=gsmith@gregsmith.com \
--cc=casus@casus.us \
--cc=linux-kernel@vger.kernel.org \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line
before the message body.
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox
all inboxes | Powered by JetHome®