Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fvRBu-0002SV-Ph for pgsql-hackers@arkaria.postgresql.org; Thu, 30 Aug 2018 17:57:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fvRBt-0007zE-6d for pgsql-hackers@arkaria.postgresql.org; Thu, 30 Aug 2018 17:57:09 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fvRBs-0007z7-6D for pgsql-hackers@lists.postgresql.org; Thu, 30 Aug 2018 17:57:09 +0000 Received: from wout2-smtp.messagingengine.com ([64.147.123.25]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fvRBk-0005zm-6f for pgsql-hackers@postgresql.org; Thu, 30 Aug 2018 17:57:07 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.west.internal (Postfix) with ESMTP id 568C1300; Thu, 30 Aug 2018 13:56:57 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute4.internal (MEProxy); Thu, 30 Aug 2018 13:56:57 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:content-type:date:from:in-reply-to:message-id:mime-version :references:subject:to:x-me-sender:x-me-sender:x-sasl-enc; s= fm2; bh=pvDewD/cPordGLOuhpHbjJ9syxdCCBCkL4eRnz0+27M=; b=gMxlBbPU yIF5b7DTl+SR0PjzBqKbID30gpPn2HwQYG1G8vABTWupmiPTmUnemPG5R+VwenOx ZHA/gs6iEY7xugqvBkYa/TmSzMNde0Pasbh3zP15Z9SND6l+qUQ24U1GiLR92M0E O8ecgbz5Ef89RCuFhJcBs7Djq7LqJ3pfJbuIpvtAyR21dRfSRPgXvoeHkObjGiKS A7ZO7Rx1uYGKacU4adjfNhccApF2p4WKTtaEz4ta7MAo586oGtbwNgi92scCG6FK 1V25Eq8ObJVVp+r68kV5l9N0OiA0f094x5KOSoSYnvZ4TzsG/D24Ve3PnqxH9kp+ z/VMI60w4nVN3Q== 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-sender :x-me-sender:x-sasl-enc; s=fm3; bh=pvDewD/cPordGLOuhpHbjJ9syxdCC BCkL4eRnz0+27M=; b=suCbblvAqDMw90JXAR9WGxlXPhyIdbFDiwWGpRJbrdnPu iuNvRQDeO9RH58mSzM06pB9YANYHUTjVtOzEM7nCW4nHC8qwPy3DglVmh1zS1X0Q O02Ya3+zU/zk5OEe505GBzoqz9hz+YUzPGS+VKfjT8+6AhWy51ANPmnGOYdf/Sxg tXCUIq3Mw2nlH7UZTyd59Ss11ol9sSrc/sFVOrcV2TK1FcR7s4HmpXuangeo+Hva e4xM7aDhO26LvXG1vge3I4nh66oaZ7r3TlWwhpdfL0boR77mehKD/RaCx3EF8TUC Zu/QjYzTDq2mNjAfjwfhYoh0UXDO5Kca6gOayN/lg== X-ME-Proxy: X-ME-Sender: Received: from paquier.xyz (unknown [208.91.3.26]) by mail.messagingengine.com (Postfix) with ESMTPA id A51921029A; Thu, 30 Aug 2018 13:56:54 -0400 (EDT) Date: Thu, 30 Aug 2018 10:56:52 -0700 From: Michael Paquier To: Tom Lane Cc: Fabien COELHO , Michael Banck , pgsql-hackers Subject: Re: pg_verify_checksums and -fno-strict-aliasing Message-ID: <20180830175652.GC15446@paquier.xyz> References: <1535618100.1286.3.camel@credativ.de> <7321.1535639966@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="9crTWz/Z+Zyzu20v" Content-Disposition: inline In-Reply-To: <7321.1535639966@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --9crTWz/Z+Zyzu20v Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Thu, Aug 30, 2018 at 10:39:26AM -0400, Tom Lane wrote: > I rather suspect that this hasn't been tested on anything but Intel > hardware, which is famously misalignment-tolerant. The lack of any > apparent regression test infrastructure for it isn't leaving a warm > feeling about how much the buildfarm is testing it. >=20 > (The right fix, of course, is to malloc the work buffer rather than > put it on the stack.) pg_upgrade/file.c is careful about that (5afcd2a), and has a comment on the matter, as does pg_standby.c. Now, grepping around for "BLCKSZ]", some garbage may have accumulated? - entrySplitPage in ginentrypage.c - rewind_copy_file_range in file.c - _hash_alloc_buckets in hashpage.c - pg_prewarm.c - blinsert.c - pg_waldump.c - logtape.c -- Michael --9crTWz/Z+Zyzu20v Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAluIL+QACgkQnvQgOdby QH38UQ//cXC5WtX5J5yeLOZidC3uWYlhZ+dxr5peFSpuKrhadAVl2pPXmBPNU/cw SyZN8LP0Y+9QkhHL25rYQyde8xjSbCP5PNAReP1Bg8NluE+5YqBYLHhgq6s4bie5 /u4SoJsh/QrfdKc417bQeWq1G2nJuAPZ9+N6JE2hP4fGZe5qQcLhIHhwrPN2Sj66 qM8MAc+rja0yPIs6HLiLftWiC1beXurAq8Dm6qUfi2qbF8i4K7QiV07xLCrlzVdj wW7quRF/qHG0GeRT7DrNB63ihwyIeYYw7FQJCl5osCUIXcVQVjdKdURR+LfpuUkp Dm2PUZ8L4SFeuRg5OjzkyRUsOF3bqdqL/0Eb/7evVTqpCrlwv7GPWZz6AxniwOLL egkbI01xe6rISnVXusmE4lMFFxc8cbr9V7sdxN890J9Gqe69Ix8jjwzxQuvsyIZ1 nGw2RV8Rb79qb/gp83vP9xjgdTr2XM1L1i2i95qSgmzjQZG3WaHLlEHUFI/mzfaz Ygjc+rs+27gYbvElyAjD3AuatXCrBOXuix6Dhee/gC4m1D1UpJ8hx9sXJroBSWgr DVYQ3KEKZpa+RJIk29E448CCdwRrX/OAHt6kh9UCxkWBclI3BtENT1Ur8OIknOru xHrPgkSDWXHgZa8PZaQ5wCl7mxjysiki9TR+WI+6NuhHsRN+r7s= =pgRL -----END PGP SIGNATURE----- --9crTWz/Z+Zyzu20v--