Re: Further reduction of bufmgr lock contention

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Further reduction of bufmgr lock contention
Дата
Msg-id 14969.1148400334@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Further reduction of bufmgr lock contention  (Gavin Hamill <gdh@acentral.co.uk>)
Ответы Re: Further reduction of bufmgr lock contention
Re: Further reduction of bufmgr lock contention
Список pgsql-hackers
Gavin Hamill <gdh@acentral.co.uk> writes:
> It's been about a month since the last activity on bufmgr as documented 
> on the hackers list and I was just concerned that this issue had been 
> filed as an interesting toy at the time, but now left for the circular 
> filing cabinet :)

> Tom + Simon were able to see a fairly easy 25% performance boost against 
> our dataset and I'd obv. be very keen to see this work make it into 
> 8.1.4 or 8.2.0 :)

We're certainly not putting any such thing into 8.1.*.  The proposed
patch for 8.2 is stalled ATM because of the problem of not having a
predictable size for the per-partition hash tables.  Fixed-size shared
memory is a harsh mistress :-(
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: file-locking and postmaster.pid
Следующее
От: Andreas Joseph Krogh
Дата:
Сообщение: Re: file-locking and postmaster.pid