Re: Some interesting results from tweaking spinlocks

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Some interesting results from tweaking spinlocks
Дата
Msg-id 200201050541.g055fmS21463@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: Some interesting results from tweaking spinlocks  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Some interesting results from tweaking spinlocks
Список pgsql-hackers
> 2. In this example, almost one in ten LWLockAcquire calls results in
> blocking (calling IpcSemaphoreLock).  That seems like a lot.  I was
> seeing much better results on a uniprocessor under essentially the
> same test: one in a thousand LWLockAcquire calls blocked, not one in
> ten.  What's causing that discrepancy?
> 
> 3. The amount of spinlock-level contention seems too high too.  We
> are calling s_lock about one out of every hundred LWLockAcquire or
> LWLockRelease calls; the equivalent figure from a uniprocessor profile
> is one in five thousand.  Given the narrow window in which the spinlock
> is held, how can the contention rate be so high?
> 
> Anyone see an explanation for these last two observations?

Isn't there tons more lock contention on an SMP machine.  I don't see
the surprise.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Some interesting results from tweaking spinlocks
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Some interesting results from tweaking spinlocks