Re: Wierd context-switching issue on Xeon

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