Re: [HACKERS] stuck spin lock with many concurrent users

[Tom Lane]

Bruce Momjian <[EMAIL PROTECTED]> writes:
>> If you estimate that a process dispatch cycle is ~ 10 microseconds,
>> then waking 999 useless processes every 10 msec is just about enough
>> to consume 100% of the CPU doing nothing useful...

> Don't we back off the sleeps or was that code removed?

Not enough to affect this calculation.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html