Re: benchmark results comparing versions 15.2 and 16

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: benchmark results comparing versions 15.2 and 16
Дата
Msg-id ZFxu+IWkQpJhZkB3@paquier.xyz
обсуждение исходный текст
Ответ на Re: benchmark results comparing versions 15.2 and 16  (Andres Freund <andres@anarazel.de>)
Ответы Re: benchmark results comparing versions 15.2 and 16  (Michael Paquier <michael@paquier.xyz>)
Список pgsql-hackers
On Tue, May 09, 2023 at 09:48:24AM -0700, Andres Freund wrote:
> On 2023-05-08 12:11:17 -0700, Andres Freund wrote:
>> I can reproduce a significant regression due to f193883fc of a workload just
>> running
>> SELECT CURRENT_TIMESTAMP;
>>
>> A single session running it on my workstation via pgbench -Mprepared gets
>> before:
>> tps = 89359.128359 (without initial connection time)
>> after:
>> tps = 83843.585152 (without initial connection time)
>>
>> Obviously this is an extreme workload, but that nevertheless seems too large
>> to just accept...
>
> Added an open item for this.

Thanks for the report, I'll come back to it and look at it at the
beginning of next week.  In the worst case, that would mean a revert
of this refactoring, I assume.
--
Michael

Вложения

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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: Redundant strlen(query) in get_rel_infos
Следующее
От: Masahiko Sawada
Дата:
Сообщение: Re: walsender performance regression due to logical decoding on standby changes