Feedback-ID: i0fe9450f:Fastmail
Date: Tue, 16 May 2023 09:42:31 +0900
From: Michael Paquier <michael@paquier.xyz>
To: Andres Freund <andres@anarazel.de>
Cc: Alexander Lakhin <exclusion@gmail.com>,
	Michael Paquier <michael.paquier@gmail.com>,
	MARK CALLAGHAN <mdcallag@gmail.com>,
	pgsql-hackers@lists.postgresql.org
Subject: Re: benchmark results comparing versions 15.2 and 16
Message-ID: <ZGLRd9RRx/47BrOP@paquier.xyz>
References: <CAFbpF8N4bVFZ+eyWFj_+fZXZFSayk2kJVtZnouUVKGHudiDrSw@mail.gmail.com>
 <b32bed1b-0746-9b20-1472-4bdc9ca66d52@gmail.com>
 <20230508191117.v6475ip6hxpwukss@awork3.anarazel.de>
 <20230509164824.wtfn5aoggj4rcz67@awork3.anarazel.de>
 <ZFxu+IWkQpJhZkB3@paquier.xyz>
 <ZGHBGE45jKW8FEpe@paquier.xyz>
 <20230516001447.xrijuuqcn5s7phuz@awork3.anarazel.de>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="RhV0g68G5/4kMGeL"
Content-Disposition: inline
In-Reply-To: <20230516001447.xrijuuqcn5s7phuz@awork3.anarazel.de>
Archived-At: <https://www.postgresql.org/message-id/ZGLRd9RRx/47BrOP%40paquier.xyz>
Precedence: bulk


--RhV0g68G5/4kMGeL
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

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.
>=20
> 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 sa=
me
> core, but even the slow performance is faster than 45k.

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

--RhV0g68G5/4kMGeL
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmRi0XcACgkQnvQgOdby
QH3DZg/9HSxgqMQnN12+n5mqDKTrseW0O7+FdpH/Vdgum4jtGP+wFqPSaw46Dpl+
huVclrDt4djNOP7o5Jl02d1Be4aAmefPn671yGXW47qXGKJIu9/BaGg3iIsi4/je
NMjvMPO7vYPJEAEEnSrMPNe12R+AMgeyn7AcUOw4zd+XrDQd2cvPo188aN0IC9NW
JtowcpR6dT7zzqOfhc/Xn4ik4pS86tndwHzHqo7ZwphicyVGM9cXp5xKarzAXSzh
dBJe5gla38Jg74x+Gs491MjN6DvWhEdw3KalfD3GjQ89gO5CkUYBG2ddRCdqFQHD
qCWxxEzBaLC+KFOVEsps1j7SQIeZDmhX+Dny+wmIdQG+kWqjmV4+fVLk7ZJKE1FX
sLt0Yr95Bd+aeX5qKq4yr2EScEUzykJxUDZRapZjL9PwQVIXtqd4ro7PDGNyz7nP
k7aqUUyJqCUckw5TrN/ASCefkQTf402Zn7TuzzY02stEvXPWV1ZLihrcx3tJEhVx
xpu6OF/07QMnBCZF5IHV9dvly7CGHdS1QjN/MHjdiIEQq5mx2XgK4q6fKAb8lr+5
N05ZACyhlWMKbb09+Xmui34J4OU5RHMUSFT8sA+S4jrD4cIgXyeNUQOyyxp2GyX5
xQ3fw/K8lBv6UuquZUPE/KvhaBatRdOemeQEkBpZansquB66VgM=
=skPP
-----END PGP SIGNATURE-----

--RhV0g68G5/4kMGeL--