Re: benchmark results comparing versions 15.2 and 16

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: benchmark results comparing versions 15.2 and 16
Дата
Msg-id 20230516005453.wrsldqhhbpy5gfnd@awork3.anarazel.de
обсуждение исходный текст
Ответ на Re: benchmark results comparing versions 15.2 and 16  (Michael Paquier <michael@paquier.xyz>)
Ответы Re: benchmark results comparing versions 15.2 and 16  (Michael Paquier <michael@paquier.xyz>)
Список pgsql-hackers
Hi,

On 2023-05-16 09:42:31 +0900, Michael Paquier wrote:
> > 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?

Yes. numactl --physcpubind ... in my case.  Linux has an optimization where it
does not need to send an IPI when the client and server are scheduled on the
same core. For single threaded ping-pong tasks like pgbench -c1, that can make
a huge difference, particularly on larger CPUs.  So you get a lot better
performance when forcing things to be colocated.

Greetings,

Andres Freund



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

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