Re: stuck spin lock with many concurrent users - Mailing list pgsql-hackers

From Tom Lane
Subject Re: stuck spin lock with many concurrent users
Date
Msg-id 26839.994216584@sss.pgh.pa.us
Whole thread Raw
In response to Re: stuck spin lock with many concurrent users  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> 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


pgsql-hackers by date:

Previous
From: "Christopher Kings-Lynne"
Date:
Subject: RE: [OT] Any major users of postgresql?
Next
From: Tom Lane
Date:
Subject: Re: Buffer access rules, and a probable bug