Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1x6UVc-000GgP-2O for pgsql-hackers@arkaria.postgresql.org; Tue, 15 Sep 2026 14:51:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1x6UVb-002Jz6-2d for pgsql-hackers@arkaria.postgresql.org; Tue, 15 Sep 2026 14:51:43 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1x6UVb-002Jyy-1W for pgsql-hackers@lists.postgresql.org; Tue, 15 Sep 2026 14:51:43 +0000 Received: from mail-yx2-x10.google.com ([2607:f8b0:4864:41::10]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1x6UVZ-00000000ClH-3ird for pgsql-hackers@lists.postgresql.org; Tue, 15 Sep 2026 14:51:42 +0000 Received: by mail-yx2-x10.google.com with SMTP id 00721157ae682-85d46e4cdcbso24610737b3.0 for ; Tue, 15 Sep 2026 07:51:41 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1789483901; x=1790088701; darn=lists.postgresql.org; h=in-reply-to:content-disposition:content-type:mime-version :references:message-id:subject:cc:to:from:date:from:to:cc:subject :date:message-id:reply-to:content-type; bh=WUSj329qMVyh/+bXAUanT9wZ2/I2GG/pf3Li/irgVGc=; b=H4EXOQgKGSRlNK+D0HnsdWLvsBhaksMe0V1q4kXMzC74mZE2FTneHtWp7yLmQ27q/6 hBmveB5nymsDk5jGmzNYTIdWZZDDY0DzXpsZvFYROYJN4X4X4srmtkd502XHrSTFhu3Z 3sboH+W2h4NLtgnijf2HPHahW2DNjMhgSMQ6rRp6c19j2mcymV9EozpFwCw7GcgSkIMB Vs6kj5iOFi+p66MV9Z+Zw8lbhx3thQyXYlqnCM/IOn0NNK9/MYvJEEk6850GZ3KIe/vZ iJk1s10KPQUOFkTxbwFRhiXiCHdS7y1Kt4lBrGlSnaZ8CHHOgaClCEGjv1+vQlGZktNV 4YUA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20260707; t=1789483901; x=1790088701; h=in-reply-to:content-disposition:content-type:mime-version :references:message-id:subject:cc:to:from:date:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to :content-type; bh=WUSj329qMVyh/+bXAUanT9wZ2/I2GG/pf3Li/irgVGc=; b=V/WqruHCPrmTaQqAPAdo2b23yTLUY0udMttKqfvxGQEq6eX/fP8O7YS8/YYqBxB22E b/ieYd8p6gGm6BvBVbedMnroytL7cuZyuGeD/1tDLV6rYsEZw8ZyEP5wfk+0TmDS/vzC FH51zXZEXvUPsVKx9aFnE9JMep9xpuVaK8FUc1yv+JzUucgjICz8HAMd1P6txiYl/6Hu loq2vytF/E8cxIv7MjFySA3reAmZSdPwkf1vNM2+cfR6nQyDyHzzJbi+r2JBTxyxDgbP hLWeWdMR9AWQBGo5QNqv0uTPD8ckhysHwnTTNNIAUSlprCQaePwpnAryfacvjXyNz7V3 BpRA== X-Gm-Message-State: AFuF++kUUjVVOw9NHOqcJl9Y+eZCWSLMbeLY0Dqvnc924jJvbTzK+ro4 vH3/E6XPT+gwGRmfUR1xOMaKqg6qyonD1r5SdyFZhuoezfVPdDxPVfBB X-Gm-Gg: AYBFou0s7VbstcQVQ5/CkVuOyDZfaCa04IuVm/YB3sNWRT76y0s0qPeRDHSOzuqTLzK +btnhuUhtDSjACTqcLLl9knF/58NKrppRxf2y2ktX8UVLIPldADG7lqneQ7RrnewrGCqkSokGoJ 3TLZC8DMf6unUh/bIXpK/jnA6uLNM1Tw6aMgkljCGtNdscVzQbKuT2DdPvMK6ZYKoDpMHNLN6v7 isWyF4u8CNZydda3Hs9jLtDWwzGAyn+uFDzYTyzivwsXPS6FAp7/8a+P/tf2stOQcAikg2YkffX EcOkZ0veh70TwLk8ObUWr+qTU8otbSHXUgDFT+6BIQahMU2CKYgX81v0migyMoXzJzCSMAW2+ZI wJT5AvBgqxqlJ9sNACdHZSbU5A9wCmbSq5a5QVURt4GOqmhEf1jWqhgrgL3U+YUbyFpC+Wd1bXo dqm1XxdAVcvSWWune2rOPIBJIb4BQrj7VTtVoU8nMxfTYR08NPQXviabQfkPGQFCpp9K2BAInk2 Fl5iW0ngQE0unnWgZ02VhbStmofBUr6ae+FyUEwmlb2TF62ElopKPokJ1pAa+X76//4lj2AzlYJ YPslAEMsUw9oodlcLwrHcmb+H2A= X-Received: by 2002:a05:690c:388:b0:858:ad19:324d with SMTP id 00721157ae682-88d1f213acbmr27895457b3.3.1789483901009; Tue, 15 Sep 2026 07:51:41 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id 00721157ae682-8848701e82fsm48719457b3.22.2026.09.15.07.51.39 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 15 Sep 2026 07:51:40 -0700 (PDT) Date: Tue, 15 Sep 2026 09:51:37 -0500 From: Nathan Bossart To: Salvatore Dipietro Cc: pgsql-hackers@lists.postgresql.org, mrdrivingduck@gmail.com, andres@anarazel.de, tgl@sss.pgh.pa.us, dipietro.salvatore@gmail.com Subject: Re: use a non-locking initial test in TAS_SPIN on AArch64 Message-ID: References: <20260915114623.431827-1-dipiets@amazon.it> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20260915114623.431827-1-dipiets@amazon.it> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, Sep 15, 2026 at 11:46:23AM +0000, Salvatore Dipietro wrote: > I'd like to propose backporting this commit 3d0b4b1068 ("Use a > non-locking initial test in TAS_SPIN on AArch64.", Nathan Bossart, > 2025-01-10), which first shipped in PostgreSQL 18, to the supported > back branches: REL_17_STABLE, REL_16_STABLE and REL_15_STABLE. I think that's fine. It was likely an oversight when AArch64 support was first added to this file, anyway. We could also back-patch to v14, but that would look a little different since it is missing commit a82a5eee31 ("Use ISB as a spin-delay instruction on ARM64"). Since v14 is set to go out-of-support in a couple months, I'd probably just stop at v15 and call it a day, though. > With huge_pages=on both effects largely disappear: huge pages mask the > paging defect, and TTAS is neutral. > > The change is a one-line, so a backport looks low-risk and would spare > pre-18 AArch64 users a severe regression as PREEMPT_LAZY kernels ship. I'm curious why you are testing without huge pages enabled. My understanding is that any serious workload on the kinds of machines you are using for your benchmarks would use them. -- nathan