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.94.2) (envelope-from ) id 1rtYTw-00FbpU-Qo for pgsql-hackers@arkaria.postgresql.org; Sun, 07 Apr 2024 19:47:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rtYTv-00BLvm-R5 for pgsql-hackers@arkaria.postgresql.org; Sun, 07 Apr 2024 19:47:11 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rtYTv-00BLtI-CQ for pgsql-hackers@lists.postgresql.org; Sun, 07 Apr 2024 19:47:11 +0000 Received: from mail-pf1-x433.google.com ([2607:f8b0:4864:20::433]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rtYTo-001RLA-Gu for pgsql-hackers@lists.postgresql.org; Sun, 07 Apr 2024 19:47:10 +0000 Received: by mail-pf1-x433.google.com with SMTP id d2e1a72fcca58-6ed2170d89fso348632b3a.1 for ; Sun, 07 Apr 2024 12:47:04 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=j-davis-com.20230601.gappssmtp.com; s=20230601; t=1712519222; x=1713124022; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:from:to:cc:subject :date:message-id:reply-to; bh=Om/snjPO5w984HnIV63/VeABgHLYmIqZk7IV6g6ucQQ=; b=mASDaXcDtVeGtYvK7NEFsPDwUcbBMOg7n+1zOBi1UYTOZpD/0elKzhyJzftXWwt6nv s1jNK54NK/B6nXxMOdNGlUwHrC0kHUTRWoIJvCrKU4sdN3KrExukwE0i/nsQ50t2zHWV P8VfHVZcabz1L7BvyBiKxXzChAHL8qZgD2yyMAHLWTKYYsJH5nGuYRssHmGDmO3AvKM6 TTAczVkxuF7lVPwNICYyHO0+xRMqmRG/pXLl/yFnWyXV5ibHIBpsdFPZBr+h3p00GJEx TDnmuuP0IHosMnw4Y2LSYyW3boycT72GzcnH1W9MlvIt5ipwVpbZglPJx1x4HSZNu0f6 LgDA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1712519222; x=1713124022; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=Om/snjPO5w984HnIV63/VeABgHLYmIqZk7IV6g6ucQQ=; b=YJH4W+7phEgxSETlDEigqOWIcEzH1rdMBIGwRbU25CjoB+RBWmZuLrTxwrKBHq21rl nbzfEUmfAYyIeVzg88ml6c5WfzgDYDfMupLcYhKQMTY9glkruSjfJCAC5Y1TErHuTOa2 XIYgyNTQI5niYmw2AuQsDqWxgjitri3Js6JGWt4t46pt8+12QGXRsX3gVN/cLvJGD+xa yu0uddxEW5ei0JShCNo5dq8XQskhcTT+gRMRXdamjr9l2M255AH+RntxE9QXLJ+uVltK GKn6J90fIIyCqU/4zv/90LCPmW2+N8IWgSlSIdjsQLK5OF4jeVe8OcWQPYRqjVNEm47j sNUg== X-Forwarded-Encrypted: i=1; AJvYcCUI0qnAH6XjvXlNnNMQPZyISdzkQmQ0EvR8qA3vyzZH6OW0A828FmZ0dF9q4gKNTzbNl2REH+EtsGtpUs7JiTB5AVSJZ3EQ+lp5j4bLerAnRg7y X-Gm-Message-State: AOJu0YyuLf1RQRjMUVNvNtXgLbJCkQCjPXxBSdF0hmf4RyJvooJTL/SN 4PV+9BFmpcnUO5yH6lHP2M7DMFNC4Qx+FdW8khFdkywrTbft+TSwYam8wzHInA== X-Google-Smtp-Source: AGHT+IH+evRFTilfnaYfZJIM/8s7qB2So26w6UpnN3mmnbc573tgRrvc2WCsSKNtY5VwcSCUjqtk8A== X-Received: by 2002:a05:6a20:2590:b0:1a7:73cc:bcfd with SMTP id k16-20020a056a20259000b001a773ccbcfdmr1093099pzd.13.1712519222496; Sun, 07 Apr 2024 12:47:02 -0700 (PDT) Received: from jeff-laptop.lan (c-76-102-242-158.hsd1.ca.comcast.net. [76.102.242.158]) by smtp.gmail.com with ESMTPSA id fb39-20020a056a002da700b006ecfc3a8d6csm4965603pfb.124.2024.04.07.12.47.01 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Sun, 07 Apr 2024 12:47:02 -0700 (PDT) Message-ID: <51111525fb84ecdadaf99c13a2fa63e4be08041e.camel@j-davis.com> Subject: Re: LogwrtResult contended spinlock From: Jeff Davis To: Alvaro Herrera Cc: Bharath Rupireddy , Tom Lane , Andres Freund , pgsql-hackers@lists.postgresql.org, Jaime Casanova Date: Sun, 07 Apr 2024 12:47:00 -0700 In-Reply-To: <202404071219.p5qphx7vzxte@alvherre.pgsql> References: <202404071219.p5qphx7vzxte@alvherre.pgsql> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.44.4-0ubuntu2 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Sun, 2024-04-07 at 14:19 +0200, Alvaro Herrera wrote: > I pushed the "copy" pointer now, except that I renamed it to > "insert", > which is what we call the operation being tracked.=C2=A0 I also added som= e > comments. The "copy" pointer, as I called it, is not the same as the "insert" pointer (as returned by GetXLogInsertRecPtr()). LSNs before the "insert" pointer are reserved for WAL inserters (and may or may not have made it to WAL buffers yet). LSNs before the "copy" pointer are written to WAL buffers with CopyXLogRecordToWAL() (and may or may not have been evicted to the OS file yet). Other than that, looks good, thank you. Regards, Jeff Davis