Horton

Re: Wierd context-switching issue on Xeon

Josh Berkus <josh@agliodbs.com>

View thread
From: Josh Berkus <josh@agliodbs.com>
To: Robert Creager <Robert_Creager@LogicalChaos.org>
Cc: pg@fastcrypt.com, Dirk_Lutzebäck <lutzeb@aeccom.com>, ohp@pyrenet.fr, Tom Lane <tgl@sss.pgh.pa.us>, Joe Conway <mail@joeconway.com>, "scott.marlowe" <scott.marlowe@ihs.com>, Bruce Momjian <pgman@candle.pha.pa.us>, pgsql-performance@postgresql.org, Neil Conway <neilc@samurai.com>
Date: 2004-04-29T18:21:51Z
Lists: pgsql-performance 
Rob,

> I would like to see the same, as I have a system that exhibits the same 
behavior
> on a production db that's running 7.4.1.

If you checked the thread follow-ups,  you'd see that *decreasing* 
spins_per_delay was not beneficial.   Instead, try increasing them, one step 
at a time:

(take baseline measurement at 100)
250
500
1000
1500
2000
3000
5000

... until you find an optimal level.   Then report the results to us!

-- 
-Josh Berkus
 Aglio Database Solutions
 San Francisco