Re: Performance under contention

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: Performance under contention
Дата
Msg-id AANLkTin=vVgkpYe2u_WBVHV59dgbe5QZ6PZ-nsT28Yb5@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Performance under contention  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: Performance under contention  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
2010/12/7 Robert Haas <robertmhaas@gmail.com>:
> 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.

Err, pretty INexpensively.

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

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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Performance under contention
Следующее
От: Vlad Arkhipov
Дата:
Сообщение: Re: Slow BLOBs restoring