Re: resowner "cold start" overhead

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: resowner "cold start" overhead
Дата
Msg-id 20221101001625.ardg5eman7oiogq2@awork3.anarazel.de
обсуждение исходный текст
Ответ на Re: resowner "cold start" overhead  (Heikki Linnakangas <hlinnaka@iki.fi>)
Список pgsql-hackers
Hi,

On 2022-10-31 11:05:32 +0100, Heikki Linnakangas wrote:
> What do you think of my ResourceOwner refactoring patches [1]? Reminded by
> this, I rebased and added it to the upcoming commitfest again.

> With that patch, all resources are stored in the same array and hash. The
> array is part of ResourceOwnerData, so it saves the allocation overhead,
> like the "initialarr" that you suggested. And it always uses the array for
> recently remembered resources, and spills over to the hash for more
> long-lived resources.
> 
> Andres, could you repeat your benchmark with [1], to see if it helps?
>
> [1] https://www.postgresql.org/message-id/2e10b71b-352e-b97b-1e47-658e2669cecb@iki.fi

Just for future readers of this thread: Replied on the other thread.

It does seem to address the performance issue, but I have some architectural
concerns.

Greetings,

Andres Freund



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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: ResourceOwner refactoring
Следующее
От: Zhihong Yu
Дата:
Сообщение: Re: heavily contended lwlocks with long wait queues scale badly