Re: benchmark results comparing versions 15.2 and 16 - Mailing list pgsql-hackers

From Andres Freund
Subject Re: benchmark results comparing versions 15.2 and 16
Date
Msg-id 20230516005453.wrsldqhhbpy5gfnd@awork3.anarazel.de
Whole thread Raw
In response to Re: benchmark results comparing versions 15.2 and 16  (Michael Paquier <michael@paquier.xyz>)
Responses Re: benchmark results comparing versions 15.2 and 16
List 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 by date:

Previous
From: Michael Paquier
Date:
Subject: Re: benchmark results comparing versions 15.2 and 16
Next
From: Andres Freund
Date:
Subject: Re: Introduce WAIT_EVENT_EXTENSION and WAIT_EVENT_BUFFER_PIN