Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1q7O2R-000232-JN
	for pgsql-hackers@arkaria.postgresql.org; Thu, 08 Jun 2023 22:23:27 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1q7O2Q-00040K-5U
	for pgsql-hackers@arkaria.postgresql.org; Thu, 08 Jun 2023 22:23:26 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <andres@anarazel.de>)
	id 1q7O2P-0003wz-RJ
	for pgsql-hackers@lists.postgresql.org; Thu, 08 Jun 2023 22:23:25 +0000
Received: from out5-smtp.messagingengine.com ([66.111.4.29])
	by magus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <andres@anarazel.de>)
	id 1q7O2F-0016L6-OL
	for pgsql-hackers@postgresql.org; Thu, 08 Jun 2023 22:23:25 +0000
Received: from compute5.internal (compute5.nyi.internal [10.202.2.45])
	by mailout.nyi.internal (Postfix) with ESMTP id B4EF75C002F;
	Thu,  8 Jun 2023 18:23:14 -0400 (EDT)
Received: from mailfrontend2 ([10.202.2.163])
  by compute5.internal (MEProxy); Thu, 08 Jun 2023 18:23:14 -0400
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=anarazel.de; h=
	cc:cc:content-type:content-type:date:date:from:from:in-reply-to
	:in-reply-to:message-id:mime-version:references:reply-to:sender
	:subject:subject:to:to; s=fm1; t=1686262994; x=1686349394; bh=2x
	y0hb1eBlVxCH9jT7xpy9ZuwEyiM0beSCPdrPEUnw4=; b=mrtDAU8nNirdu7yHj/
	qYwG0eJ9fRKek8f02klV6WGQ0HdwxEluS4NYw6QLI5aKVQXYp0xBJfKMQdQGD/CY
	OrVhYp3O4f0rzUoPK/xbbT+bZ2ZFRKMUTQbJmROlESV69VqqbOeDC+iCRwccXTi3
	wG1BxRRb9Sq2Bp3+B56lEnJ/0TeuDipsdZALtJHsiLpdbCRrGH155EO5EDakLTEf
	2CMfkw7ALWji2kF/59kVql6MeoQJuG54RzSBjdJqoq/AjPBPQy8C2oWjegQfte3P
	lu/5inPoVgpPOLcY16INJhjWDJUTxq4AMBqbvctEd3ZExMDBoqeKKlNOxaakXtHk
	Cppw==
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=
	messagingengine.com; h=cc:cc:content-type:content-type:date:date
	:feedback-id:feedback-id:from:from:in-reply-to:in-reply-to
	:message-id:mime-version:references:reply-to:sender:subject
	:subject:to:to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender
	:x-sasl-enc; s=fm1; t=1686262994; x=1686349394; bh=2xy0hb1eBlVxC
	H9jT7xpy9ZuwEyiM0beSCPdrPEUnw4=; b=O9o7v9SxVt3qr62CD2s1KpoJhsy7k
	HGJgLtIcjgH71LPUZHaaatcyY8vJuu92St6H5cv5OIAY9GcGYweZrzclzv9V57pL
	0/8JqxA7ng/VIOdwuoutKJBZA/pr9Q5xq0eRx+nsa8KYWKsdayLDX63OlITXMgWU
	aPpwNBzDiAlOjnvqD3rA7VQySkOrvNH6yIEFvC0okgye+scjRoiKBLF7x0jatj6U
	pchYF9fVUrk2FXsDXjXXvnOEyUUWZJRFRdNYAClm4uL5S8WCUxGGvc2bAFwODDo+
	3wtmj9oV17WAGtwYVDWpo178tmEkwlNvr4VhTnxVk2GDBa7kREhQHeMOA==
X-ME-Sender: <xms:0lSCZEZHY2iXygZNPX4WwyH3VrU1ZqhMHxDv3YF9Bnp3ijFkSdxKZw>
    <xme:0lSCZPZYzFRc4kvTAzBivxCqsaoqsyhE5qYQoXYsGDvHlBrqFOQUt5vL-BRssfUF0
    EUx6K0vcRnzI3nTxw>
X-ME-Received: <xmr:0lSCZO88FwEESW4rka7AuV-YohE0tiNLsRzkCwaDybT232Nmnp7BSybwNnOeVXElC_thetTbrvJ2wCybRJV3I4wPOq5ChrGTOsSU5MfCUxJsMfhCENJVCh8LDxOn>
X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvhedrgedtjedgtdekucetufdoteggodetrfdotf
    fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen
    uceurghilhhouhhtmecufedttdenucenucfjughrpeffhffvvefukfhfgggtuggjsehttd
    ertddttddvnecuhfhrohhmpeetnhgurhgvshcuhfhrvghunhguuceorghnughrvghssegr
    nhgrrhgriigvlhdruggvqeenucggtffrrghtthgvrhhnpedvffefvefhteevffegieetfe
    fhtddvffejvefhueetgeeludehteevudeitedtudenucevlhhushhtvghrufhiiigvpedt
    necurfgrrhgrmhepmhgrihhlfhhrohhmpegrnhgurhgvshesrghnrghrrgiivghlrdguvg
X-ME-Proxy: <xmx:0lSCZOoX2wrjkC4yU4DZAegcgOm5ZTx5DN4Oek0PXQAoD37g1pOaIA>
    <xmx:0lSCZPouwaq00wAP8laBEdXRy9Q5WD6Mhd8qWPIAdXymUR52vH2Gfg>
    <xmx:0lSCZMQ41N-h-mLdZZCjtbO2g393SrRuBoEXFxbO_HH15L92P_KrQw>
    <xmx:0lSCZORor_o1gYs8s65GqFljDDQ3vlLH-zfJVdeAOgRHJXJTHiwf4Q>
Feedback-ID: id4a34324:Fastmail
Received: by mail.messagingengine.com (Postfix) with ESMTPA; Thu,
 8 Jun 2023 18:23:14 -0400 (EDT)
Date: Thu, 8 Jun 2023 15:23:13 -0700
From: Andres Freund <andres@anarazel.de>
To: Gregory Smith <gregsmithpgsql@gmail.com>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Subject: Re: Major pgbench synthetic SELECT workload regression, Ubuntu
 23.04+PG15
Message-ID: <20230608222313.gqkg2gcrqcxtvk6o@awork3.anarazel.de>
References: <CAHLJuCUFGcDb1OkBcLtuWoXv5aPbWMj9uSm3q-AR3CA9CcYp_Q@mail.gmail.com>
 <20230608221807.p77h43zotlfvkg65@awork3.anarazel.de>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <20230608221807.p77h43zotlfvkg65@awork3.anarazel.de>
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Archived-At: <https://www.postgresql.org/message-id/20230608222313.gqkg2gcrqcxtvk6o%40awork3.anarazel.de>
Precedence: bulk

Hi,

On 2023-06-08 15:18:07 -0700, Andres Freund wrote:
> E.g. on my workstation (two sockets, 10 cores/20 threads each), with 32
> clients, performance changes back and forth between ~600k and ~850k. Whereas
> with 42 clients, it's steadily at 1.1M, with little variance.

FWIW, this is with linux 6.2.12, compiled by myself though.

Greetings,

Andres Freund