Re: heavily contended lwlocks with long wait queues scale badly

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: heavily contended lwlocks with long wait queues scale badly
Дата
Msg-id ZadxZFxWFVwf6Mgt@paquier.xyz
обсуждение исходный текст
Ответ на Re: heavily contended lwlocks with long wait queues scale badly  ("Jonathan S. Katz" <jkatz@postgresql.org>)
Список pgsql-hackers
On Tue, Jan 16, 2024 at 11:24:49PM -0500, Jonathan S. Katz wrote:
> On 1/16/24 1:11 AM, Michael Paquier wrote:
>> I'd like to apply that, just let me know if you have any comments
>> and/or objections.
>
> Looking at the code, I understand an argument for not backpatching given we
> modify the struct, but this does seem low-risk/high-reward and should help
> PostgreSQL to run better on this higher throughput workloads.

Just to be clear here.  I have repeated tests on all the stable
branches yesterday, and the TPS falls off drastically around 256
concurrent sessions for all of them with patterns similar to what I've
posted for 12, getting back a lot of performance for the cases with
more than 1k connections.
--
Michael

Вложения

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

Предыдущее
От: li jie
Дата:
Сообщение: Reduce useless changes before reassembly during logical replication
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: Fix a possible socket leak at Windows (src/backend/port/win32/socket.c)