Re: RESOLVED: Re: Wierd context-switching issue on Xeon

=?ISO-8859-1?Q?Dirk_Lutzeb=E4ck?= <lutzeb@aeccom.com> writes:
> This was the key to look at: we were missing all indices on table which 
> is used heavily and does lots of locking. After recreating the missing 
> indices the production system performed normal. No, more excessive 
> semop() calls, load way below 1.0, CS over 20.000 very rare, more in 
> thousands realm and less.

Hmm ... that's darn interesting.  AFAICT the test case I am looking at
for Josh's client has no such SQL-level problem ... but I will go back
and double check ...

			regards, tom lane