Re: Performance under contention

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: Performance under contention
Дата
Msg-id AANLkTim2nr+pKJ6ZwduEthzdV94=Ovh9ys_E6nEZCWbr@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Performance under contention  (Віталій Тимчишин <tivv00@gmail.com>)
Ответы Re: Performance under contention  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-performance
2010/12/7 Віталій Тимчишин <tivv00@gmail.com>:
> As far as I can see from the source, there is a lot of code executed under
> the partition lock protection, like two hash searches (and possibly
> allocations).

Yeah, that was my concern, too, though Tom seems skeptical (perhaps
rightly).  And I'm not really sure why the PROCLOCKs need to be in a
hash table anyway - if we know the PROC and LOCK we can surely look up
the PROCLOCK pretty expensively by following the PROC SHM_QUEUE.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

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

Предыдущее
От: Ivan Voras
Дата:
Сообщение: Re: Performance under contention
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Performance under contention