Tom,
> As far as I can tell, this does reduce the rate of semop's
> significantly, but it does so by bringing the overall processing rate
> to a crawl :-(. I see 97% CPU idle time when using this patch.
> I believe what is happening is that the select() delay in s_lock.c is
> being hit frequently because the spin loop isn't allowed to run long
> enough to let the other processor get out of the spinlock.
Also, I tested it on production data, and it reduces the CSes by about 40%.
An improvement, but not a magic bullet.
--
Josh Berkus
Aglio Database Solutions
San Francisco
