Re: benchmark results comparing versions 15.2 and 16

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: benchmark results comparing versions 15.2 and 16
Дата
Msg-id ZGLRd9RRx/47BrOP@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  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers
On Mon, May 15, 2023 at 05:14:47PM -0700, Andres Freund wrote:
> On 2023-05-15 14:20:24 +0900, Michael Paquier wrote:
>> On Thu, May 11, 2023 at 01:28:40PM +0900, Michael Paquier wrote:
>> Extreme is adapted for a worst-case scenario.  Looking at my notes
>> from a few months back, that's kind of what I did on my laptop, which
>> was the only machine I had at hand back then:
>> - Compilation of code with -O2.
>
> I assume without assertions as well?

Yup, no assertions.

> 45k seems too low for a modern machine, given that I get > 80k in such a
> workload, on a workstation with server CPUs (i.e. many cores, but not that
> fast individually).  Hence wondering about assertions being enabled...

Nope, disabled.

> I get quite variable performance if I don't pin client / server to the same
> core, but even the slow performance is faster than 45k.

Okay.  You mean with something like taskset or similar, I guess?
--
Michael

Вложения

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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: Introduce WAIT_EVENT_EXTENSION and WAIT_EVENT_BUFFER_PIN
Следующее
От: Andres Freund
Дата:
Сообщение: Re: benchmark results comparing versions 15.2 and 16