Re: Spinlocks, yet again: analysis and proposed patches

Поиск
Список
Период
Сортировка
От Emil Briggs
Тема Re: Spinlocks, yet again: analysis and proposed patches
Дата
Msg-id 200510121507.23413.emil@baymountain.com
обсуждение исходный текст
Ответ на Re: Spinlocks, yet again: analysis and proposed patches  (Simon Riggs <simon@2ndquadrant.com>)
Ответы Re: Spinlocks, yet again: analysis and proposed patches  ("Jim C. Nasby" <jnasby@pervasive.com>)
Список pgsql-hackers
> where the number of padding locks is determined by how many lock
> structures fit within a 128 byte cache line.
>
> This isn't exactly elegant coding, but it provides a useful improvement
> on an 8-way SMP box when run on 8.0 base. OK, lets be brutal: this looks
> pretty darn stupid. But it does follow the CPU optimization handbook
> advice and I did see a noticeable improvement in performance and a
> reduction in context switching.
>
> I'm not in a position to try this again now on 8.1beta, but I'd welcome
> a performance test result from anybody that is. I'll supply a patch
> against 8.1beta for anyone wanting to test this.
>

I don't have an 8 way available right now but I can run tests on a 4 way 
Opteron if that would be helpful. 

Emil



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

Предыдущее
От: "Ilia Kantor"
Дата:
Сообщение: Re: slow IN() clause for many cases
Следующее
От: "Jonah H. Harris"
Дата:
Сообщение: Re: slow IN() clause for many cases