Re: Do we need so many hint bits?

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: Do we need so many hint bits?
Дата
Msg-id 201211181519.33154.andres@2ndquadrant.com
обсуждение исходный текст
Ответ на Re: Do we need so many hint bits?  (Jeff Davis <pgsql@j-davis.com>)
Ответы Re: Do we need so many hint bits?  (Jeff Davis <pgsql@j-davis.com>)
Список pgsql-hackers
On Sunday, November 18, 2012 03:07:01 AM Jeff Davis wrote:
> Process A (process that clears a VM bit for a data page):
>   1. Acquires exclusive lock on data buffer
>   2. Acquires exclusive lock on VM buffer
>   3. clears VM bit
>   4. Releases VM buffer lock
>   5. Releases data buffer lock

Well, but right this is a rather big difference. If vm pages get 
unconditionally locked all the time we will have a huge source of new 
contention as they are shared between so many heap pages.

Andres
-- 
Andres Freund        http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services



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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: Do we need so many hint bits?
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: Do we need so many hint bits?