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 1lUezp-0003BY-RR for pgsql-committers@arkaria.postgresql.org; Fri, 09 Apr 2021 00:27:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lUezo-0002Fr-Pc for pgsql-committers@arkaria.postgresql.org; Fri, 09 Apr 2021 00:27:36 +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 1lUezo-0002C2-Ju for pgsql-committers@lists.postgresql.org; Fri, 09 Apr 2021 00:27:36 +0000 Received: from out2-smtp.messagingengine.com ([66.111.4.26]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lUezm-000259-Bv for pgsql-committers@lists.postgresql.org; Fri, 09 Apr 2021 00:27:35 +0000 Received: from compute3.internal (compute3.nyi.internal [10.202.2.43]) by mailout.nyi.internal (Postfix) with ESMTP id 437525C00F9; Thu, 8 Apr 2021 20:27:33 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute3.internal (MEProxy); Thu, 08 Apr 2021 20:27:33 -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=fm1; bh=N97PLb+VkbxMAJFO5ZmhqzEL43d QOsHc59klUFa73Io=; b=zQOdL6/Z0CX/jXlc+abPHgdvFBCF8O8ul6pFieh3BtT OrbcNwLuqWXBzHZPEp+ui7lz2YueENOOQnZ/v7LEfmWjRdUN6uowHlNBwZhUgaRO 3ijG4X76eEnh32gVynsx1uEde5Gc13rUIyRa9MwRZHYayx2FDz/L3KfU+pxJ+FBn FiXz+dov/ttZHDGhbTr0h6brveF9PBYNl9p9fmXG/MOgWVmSHNSyy9bxZysRvPD5 wLYf9ExZJwS51EvNqJjuiaQ6MiAjNS9oSd0I2QVSMPlc9oKnRoQTRuv9kTS3Rvz6 mdge4qoZI3KMnyqfiLpVUIk0ARvDX0WnSi25Woz+goA== 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=fm2; bh=N97PLb +VkbxMAJFO5ZmhqzEL43dQOsHc59klUFa73Io=; b=rwN/2pWCgT7SWoaGSZibYr ckwAsm8IQcMgTVP8p2XyWFtRH5rXdNqg6Dv0iEBVumkiZjwQzGmN3CJ6QhbHaOWd xNKPDAQSxvPSrohI48zEQQjpY+fV5djIp4nl+7/p19AU8T+G7nbSCWRptAcxR0kz 1slh0HN+m3ZLVXnoYOfqyb8l3IJKJhx6NOZyFb/OkH2FFR58NYQbGKY77rE7D6ce LJfLvI4T9g9Jr4tsfJFQErmqRhXGTD0w+KvJ7Pjn+tQBqUmDnTmCeXff5NHUdU8M K1OuexBJ4aPsGYIXcIEL+5MMeWc0i3jOWVFWXkT67MHKdAwGSxOPAR8cJSHZWeCA == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduledrudektddgfeefucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne gfrhhlucfvnfffucdljedtmdenucfjughrpeffhffvuffkfhggtggujgesghdtreertddt vdenucfhrhhomhepofhitghhrggvlhcurfgrqhhuihgvrhcuoehmihgthhgrvghlsehprg hquhhivghrrdighiiiqeenucggtffrrghtthgvrhhnpedvgeduuefhtdeuleettdevjeeh heeiveeuieegleetgeeljeelieeuieehgeevhfenucfkphepudduuddruddtvddrudektd drudekheenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhm pehmihgthhgrvghlsehprghquhhivghrrdighiii 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 685151080066; Thu, 8 Apr 2021 20:27:31 -0400 (EDT) Date: Fri, 9 Apr 2021 09:27:27 +0900 From: Michael Paquier To: Andres Freund Cc: pgsql-committers@lists.postgresql.org Subject: Re: pgsql: SQL-standard function body Message-ID: References: <20210407225806.majgznh4lk34hjvu@alap3.anarazel.de> <1730972.1617836766@sss.pgh.pa.us> <20210408015017.yb2tb324y6zt4o66@alap3.anarazel.de> <42affe76-48c4-a78c-e548-83a16b806af2@dunslane.net> <1846548.1617893536@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="2S05Yg01J84N7Mmx" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --2S05Yg01J84N7Mmx Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Thu, Apr 08, 2021 at 07:56:10AM -0700, Andres Freund wrote: > IIRC we made it run with fsync explicitly enabled. Which obviously > will change timing somewhat substantially... Yeah. I think that this kind of things pretty much boils down into making the tests of pg_upgrade into TAP. We have already a set of rather-sane defaults in PostgresNode. This does not prevent just sticking one or two extra configuration lines into test.sh, of course. -- Michael --2S05Yg01J84N7Mmx Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmBvn28ACgkQnvQgOdby QH1wbxAAjQikSOH27uAbkDvYZf0j/h2EvY1ZKzVa2sS6YrQ0XByx3nuZNrATajaG GpNqlHpCbVEQJFVRwdfIbIDXUzWPMrnuK1l/tRK3Qqa13iLV8iYtcE+f5yL1V3KA JRbraoc6Ghq2vcywmqBno9nclnoGVOWN+mKkb48SH+yWlwMR02qlAd5vJCFNBODd gVLV8ApIM0LQVtbVVUf+S6aPcFszV8bS8xq8mZVB28kCkEepZmpSIIT1fOBASODm l24fiRndUosugChmqMpbIqs+DX4clio5IDmQyBFLlwQCMtHMp9lr7GtT6M478CAH j34oMszKpmWmRM13UsmPxE5J5GuFqED+ymH5J6/D2ELjHDZefJelXcytRuD0/obK bAuywwauCwKfjvHxfbS7cNWh3Mg7A5pfR0qerd28blAHCAzGwpTt7U1ks7c+g1Lp Jbyf4/dRiBC9m7MDdSYJssDhmMztERGJDs8WUm2NMkhgfuBtDIGu2QkimitCmGh8 8eUalB5JJcg2Qy/3GLaSN19fzEH24DLBqqsm5GRuhcULmEsMXmDKYcX0d/KbIF63 q0KxKG1P7KKSLrWGuT88DXREUTE/Q2Tdmv6iPrsYwAgTjN2Z2guuwyPNC+DA1Kd2 rmbqqO53Bk2nKc/K0NomQl2v0vgI9QUJnDZbSrhY9KdEeMqhiuM= =BTRF -----END PGP SIGNATURE----- --2S05Yg01J84N7Mmx--