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 1nbWPn-0001Qf-BL for pgsql-hackers@arkaria.postgresql.org; Mon, 04 Apr 2022 23:47:20 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nbWOn-00033C-U5 for pgsql-hackers@arkaria.postgresql.org; Mon, 04 Apr 2022 23:46:17 +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 1nbWOm-000333-E2 for pgsql-hackers@lists.postgresql.org; Mon, 04 Apr 2022 23:46:17 +0000 Received: from out3-smtp.messagingengine.com ([66.111.4.27]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nbWOj-0000kO-SO for pgsql-hackers@postgresql.org; Mon, 04 Apr 2022 23:46:15 +0000 Received: from compute5.internal (compute5.nyi.internal [10.202.2.45]) by mailout.nyi.internal (Postfix) with ESMTP id 631095C0736; Mon, 4 Apr 2022 19:46:12 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute5.internal (MEProxy); Mon, 04 Apr 2022 19:46:12 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:cc:content-type:date:date:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:sender:subject :subject:to:to; s=fm1; bh=U6NOm5MFTObbNztII9oodYIcN2bYYfRg3BS7iv FzAb4=; b=Pisx6rpzRFLotc8inGhbc2H4MsnRLu5uEzR3xVrr9YXSeIrwIHnS4/ i67XGdE2rMIXDAYTvHiGhinzfp+lfeysK9Cjhhfy4gZRUE4FHQERKdITbCFCglOT EeBo3Hz/4J/j04SPSajwN+43L6W3gUMd8hI+Pd2lei/lOZE1j9YA8Sg65a5RPZvP nKkM3K9t5ty/1lW0i/6H1YyEfyi56Py2zbkwmL5ZV939nP4FpfOXtJbdlJ+iWEAT +/r0VCLhLorvqH4JY7zgv0aMx0YrS09HdHvOgOlpYb47FzojRK5EhYGPiwiQ7h4K HoDtmJskvEIUTpUwTaDsUt6AAZJjHYfQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:date:date:from:from :in-reply-to:in-reply-to:message-id:mime-version:references :reply-to:sender:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm3; bh=U6NOm5MFTObbNztII 9oodYIcN2bYYfRg3BS7ivFzAb4=; b=ipMcF/i2LMsKWcaxRpOBDJuTLQof8yiLs k9GRkonzs2PfPloKIa4uilrplz5eQsHBt1sBG9bH+v4MIxRzOgCMW/z6ToHzBjdr UyPuRK0X1yxocoVxaGWH/zw1eN25qBzp8zToNrpVEfRcXIxWugM+Xbu9sWE7uZib dInXtVYWwsm+SSdMJUVS6upPen4B8PvpE0Xh4zdkA9nKSId8PT97bSd6SsUVnxLZ renxhyuqlqIv4f5P0mUOW+vLWMii/Ee8NHMbRyOuhsxeX5XbVcqadqMPsZS9ZZRD J/zA6m78Wi64moV//FMnDLAZweowfdYx+i54myDJy3SL6YIjQdXkg== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvvddrudejfedgvdeiucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne gfrhhlucfvnfffucdljedtmdenucfjughrpeffhffvuffkfhggtggujgesghdtreertddt vdenucfhrhhomhepofhitghhrggvlhcurfgrqhhuihgvrhcuoehmihgthhgrvghlsehprg hquhhivghrrdighiiiqeenucggtffrrghtthgvrhhnpeettdejgeehjeduffdtgeekkefg ffeihfduffekheevgfetkeefveevjeffkeehleenucffohhmrghinheprhgvghhrvghssh drphhlnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomhep mhhitghhrggvlhesphgrqhhuihgvrhdrgiihii X-ME-Proxy: Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 4 Apr 2022 19:46:10 -0400 (EDT) Date: Tue, 5 Apr 2022 08:46:06 +0900 From: Michael Paquier To: Andres Freund Cc: pgsql-hackers@postgresql.org Subject: Re: Run pg_amcheck in 002_pg_upgrade.pl and 027_stream_regress.pl? Message-ID: References: <20220403185303.futnxfj64llw4uny@alap3.anarazel.de> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="7BCH0Hpfz3gEVc4G" Content-Disposition: inline In-Reply-To: <20220403185303.futnxfj64llw4uny@alap3.anarazel.de> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --7BCH0Hpfz3gEVc4G Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Sun, Apr 03, 2022 at 11:53:03AM -0700, Andres Freund wrote: > It seems $subject would have a chance of catching some of these bugs, as well > as exposing amcheck to a database with a bit more varied content? Makes sense to me to extend that. > Depending on the cost it might make sense to do this optionally, via > PG_TEST_EXTRA? Yes, it would be good to check the difference in run-time before introducing more. A logical dump of the regression database is no more than 15MB if I recall correctly, so my guess is that most of the runtime is still going to be eaten by the run of pg_regress. -- Michael --7BCH0Hpfz3gEVc4G Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmJLgz4ACgkQnvQgOdby QH3Rkg//aJ51hA4+bwGS722yrdrxEhfHFkh4saM/Xb/S/tcFZqpDrZqx68s00GLb y6v7g9Nx7W6FZslDC+RUqVKaiRs60azRsZwjA7aomKS6j21VvIWb6l6vYEW9Dn92 sylb3odLesxzzyLIGogHSHURb+C4xIv7x0s5PxUi44H4Z9xYge2IJFuMzOyIjL3G I0kZisuZ/Jwtatk4Sn/bkD5a4hnDCnXadZ0uSbabTBnFpBgK4bjqgafOZMgW5h61 Nlb5q2QudwxbWL6B7PExigTi0MH8qM4hWz1fzvPHfIMGX6wRhKneXyzoSQBNFh2V 5j3GCXVbqGYkNkX4VyMeBeANyLh4Ue9EhD+xrSivypBj/fStiUIn7ez4Yh0Y+vTf PYVbO7G1j6EIamX8iWEzdbnduqt3nlhXW96XCWBBvDsOK8cnFK2u//tSvCcRxVGn 5y6hrEAF1Vk8urQ7tNj17d13KqvCQ/W3DQAVfhDH8EaAxOrqJO8t2kRENoOj1N+U CAAsHOtBlbyk18+3O1f1xmXgsbTUnoP1LxyWOvoDgmn6VGKYFSI/bqWujh+d58FO AQxkJE2pMJjuNP206tOp0PAzcN00Npkcx5ymbycQamWeeNz6XMqu+p1DIH/7g9RG m3Xfv5WYugTK8pJFdoxTkYfNUkMRWqv5H0OeOwm9XUBFqZqkWpI= =irhg -----END PGP SIGNATURE----- --7BCH0Hpfz3gEVc4G--