From: Josh Berkus <josh@agliodbs.com>
To: Joe Conway <mail@joeconway.com>
To: scott.marlowe <scott.marlowe@ihs.com>
Cc: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: lutzeb@aeccom.com, pgsql-performance@postgresql.org, Neil Conway <neilc@samurai.com>
Subject: Re: Wierd context-switching issue on Xeon
Date: Mon, 19 Apr 2004 14:55:04 -0700
Message-ID: <200404191455.04068.josh@agliodbs.com> (raw)
In-Reply-To: <40843E63.7050101@joeconway.com>
References: <Pine.LNX.4.33.0404191410550.17372-100000@css120.ihs.com>
<40843E63.7050101@joeconway.com>
Joe,
> I've got a quad 2.8Ghz MP Xeon (IBM x445) that I could test on. Does
> anyone have a test set that can reliably reproduce the problem?
Unfortunately we can't seem to come up with one. So far we have 2 machines
that exhibit the issue, and their databases are highly confidential (State of
WA education data).
It does seem to require a database which is in the many GB (> 10GB), and a
situation where a small subset of the data is getting hit repeatedly by
multiple processes. So you could try your own data warehouse, making sure
that you have at least 4 connections hitting one query after another.
--
-Josh Berkus
Aglio Database Solutions
San Francisco
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: josh@agliodbs.com, mail@joeconway.com, scott.marlowe@ihs.com, pgman@candle.pha.pa.us, tgl@sss.pgh.pa.us, neilc@samurai.com
Subject: Re: Wierd context-switching issue on Xeon
In-Reply-To: <200404191455.04068.josh@agliodbs.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