> 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.
Aglio Database Solutions
In response to
pgsql-performance by date
|Next:||From: Dave Cramer||Date: 2004-04-22 03:06:41|
|Subject: Re: Wierd context-switching issue on Xeon patch for 7.4.1|
|Previous:||From: Tom Lane||Date: 2004-04-22 02:35:30|
|Subject: Re: Wierd context-switching issue on Xeon patch for 7.4.1 |