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


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Reply via email to