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 ) id 1kXdho-0004Z1-6G for pgsql-hackers@arkaria.postgresql.org; Wed, 28 Oct 2020 05:09:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kXdhn-0002z0-38 for pgsql-hackers@arkaria.postgresql.org; Wed, 28 Oct 2020 05:09:03 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kXdhl-0002xW-R6 for pgsql-hackers@lists.postgresql.org; Wed, 28 Oct 2020 05:09:02 +0000 Received: from wout4-smtp.messagingengine.com ([64.147.123.20]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kXdhj-0008Kg-4w for pgsql-hackers@lists.postgresql.org; Wed, 28 Oct 2020 05:09:00 +0000 Received: from compute1.internal (compute1.nyi.internal [10.202.2.41]) by mailout.west.internal (Postfix) with ESMTP id 90676A93; Wed, 28 Oct 2020 01:08:57 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute1.internal (MEProxy); Wed, 28 Oct 2020 01:08:58 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= date:from:to:cc:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm3; bh=cXBrTq4q0IUtCArkiWPwJPa5J4u QxL+F2PvYT31q/Ok=; b=h+TAP6Vdz02ogKS9GfEJmN4r4sVHcHDrTo1rpgf+o81 8PdjIHgT8btczdUZTNaHWq/YTkJwfdaPwtEJdMpmL75sD+dICcmC4snRtBwxAgzS T+DZKNLjzgaSSyera2R/ZBFf5nMnkNkGoQDlOpF7YHb41RRB/2w5bQM65JVGmG0h W9JtiydYwlwzBcGpmKj3bpQZZG0OgCjy0ujsHf5dC+s4/wgr3jgJB7L4wGVIY4UO HFAZcwyuJK9p949Vh+o/bFysnw9ekJOBZbuaOQx+D1DUMgdgWJxD5qtmRdzyBzAK x7gvBD59+WpcAfjlnD9RTsRVdL9/MJ94phzfbtXQbtw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm1; bh=cXBrTq 4q0IUtCArkiWPwJPa5J4uQxL+F2PvYT31q/Ok=; b=Ut15IdBxxVox/Y4ipXiIfO x1+TgPh4XjzeQokyQ+/+04SMzv7wH+b3iVe5XnxAVwUfx1pmoasd+KfLFcO+nBuI 8mqYjzFaA6zxPe0U6h8LEt3V5yS7R/f8GzaGawGLObn5VjKeoFT5AvR508MtEkt3 wXJSiTlPsc1l+nTOhusrjDeiT0qyr/TDzzP4WoaO5QZP7b6DS/FBl5mJ/gi6vewJ yEmV3YESYnFh/g8iWV4DyuT73dcQ+u2YsBRFwBPszihyW4SQOFPCPRMbX51SZx4Z izP6xdFPv8OS/Z+gtbh5kiBUrIL2MPOnjY41t9URTBV5Is0XT2O4aYO5+FqN5ihA == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedujedrledtgdejkecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenfg hrlhcuvffnffculdejtddmnecujfgurhepfffhvffukfhfgggtuggjsehgtderredttddv necuhfhrohhmpefoihgthhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesphgrqh huihgvrhdrgiihiieqnecuggftrfgrthhtvghrnhepvdegudeuhfdtueeltedtveejheeh ieevueeigeelteegleejleeiueeiheegvefhnecukfhppeduuddurddutddvrddukedtrd dukeehnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomhep mhhitghhrggvlhesphgrqhhuihgvrhdrgiihii X-ME-Proxy: Received: from paquier.xyz (ee0822lan1.rev.em-net.ne.jp [111.102.180.185]) by mail.messagingengine.com (Postfix) with ESMTPA id 338F63064674; Wed, 28 Oct 2020 01:08:54 -0400 (EDT) Date: Wed, 28 Oct 2020 14:08:52 +0900 From: Michael Paquier To: Julien Rouhaud Cc: Justin Pryzby , Masahiko Sawada , Robert Haas , PostgreSQL Hackers , Masahiko Sawada Subject: Re: Online checksums verification in the backend Message-ID: <20201028050852.GF28445@paquier.xyz> References: <20201019023918.GB9612@paquier.xyz> <20201019075248.GD9612@paquier.xyz> <20201023072832.GE5180@paquier.xyz> <20201023090630.GA26347@paquier.xyz> <20201027070746.GD28445@paquier.xyz> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="OpLPJvDmhXTZE4Lg" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --OpLPJvDmhXTZE4Lg Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Tue, Oct 27, 2020 at 07:47:19PM +0800, Julien Rouhaud wrote: > I think it's also worth noting that the IOLock is now acquired just > before getting the buffer state, and released after the read (or after > finding that the buffer is dirty). This is consistent with how it's > done elsewhere, so I'm fine. Consistency is the point. This API should be safe to use by design. I have done some extra performance tests similar to what I did upthread, and this version showed similar numbers. > Other than that I'm quite happy with the changes you made, thanks a lot! Thanks for confirming. I have gone through the whole set today, splitted the thing into two commits and applied them. We had buildfarm member florican complain about a mistake in one of the GetDatum() calls that I took care of already, and there is nothing else on my radar. -- Michael --OpLPJvDmhXTZE4Lg Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl+Y/OQACgkQnvQgOdby QH38wA/8DMaYV6RHywRYhdHaEHaS4Kg2VLm/6wAwUyPUBOHz9AktSwSolthPnBzQ s+hqjJqUV0uq6q9k660wXSku+hBv1WXYAnonkciBRWAJkzvgIpSsG0D/+j1PoK7f s4Ok/FRpws5gHy+V1p8QgcLVXy7f/LBJUjhdutqHHpi2KWnuIUkVLIdZnUs1L+RB y25zANpjMuaYSCdNYJUB2fneOUeOmqPMXFqUvYcuxxaDvWg56htaiRTZK3ACcZPN KgNWvCh4KShmUzNz45+/xE/EcCOXHEaeVwPjq4JFKVm/pyHye2Z+rptlTIH6GcSW IDnGFldwqeUCTsQvCghgEUTvQxazHA4F3w2jDDzeFukXqq0kkGAxMfSJJa1/cCOO pOvlYUqNnXldP4rJ6svPPhQZTJnJUpS+MNLEgRze//q7FtJZsLiI+ogKNAVRwiA3 1FcxLjTQCxwqCP8tMKasRB4qEd4UWHM38GNb3idqX1oE07T5Mc8RKOGThnqu39O/ niCV9xW7hFOY7kRGMhPwpr0af+7T4ksKgD8TXCTkTqAhkqzWalx6239lq0FZ2Mp/ NwtPIiCmDNltJyUx1Xw04UKyF2cqiu+If/mkSKK0yw8rqioaIClbtTs7jNpkzyB5 8P94Q6h6HlRtuzO3KlT6zWyfsc1JonQpPfynsRr3SLkdRFljfWg= =/OzA -----END PGP SIGNATURE----- --OpLPJvDmhXTZE4Lg--