Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hSmbR-00041G-Vi for pgsql-committers@arkaria.postgresql.org; Mon, 20 May 2019 18:01:38 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hSmaS-0003Eq-Bm for pgsql-committers@arkaria.postgresql.org; Mon, 20 May 2019 18:00:36 +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_SHA1:256) (Exim 4.89) (envelope-from ) id 1hSmaR-0003Cn-8Y for pgsql-committers@lists.postgresql.org; Mon, 20 May 2019 18:00:36 +0000 Received: from out3-smtp.messagingengine.com ([66.111.4.27]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hSmaO-0004Nz-8u for pgsql-committers@lists.postgresql.org; Mon, 20 May 2019 18:00:34 +0000 Received: from compute5.internal (compute5.nyi.internal [10.202.2.45]) by mailout.nyi.internal (Postfix) with ESMTP id 15CFC245E4; Mon, 20 May 2019 14:00:31 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute5.internal (MEProxy); Mon, 20 May 2019 14:00:31 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=anarazel.de; h= date:from:to:cc:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm1; bh=btaDgSmOB591jWL9FauawxR9EvM aPH1vS9Fhmr39ScM=; b=YyYCNxgl9aIKu6BY+Bg+ZTRwqQdlqztFKtfkZBQglDN gphBMexyK7Liix9QCLD5FSzLR8lLNkgKUn8h00e2/ZLvIJTFlPfxFVZGue+AFpAz Sf/iB33htws8EIjcVyS2kW73Yc2gd84Jo9urCpxctsIG35qblptue2uISqgLWe9w LBtSKhtPFKAy6upK/H3FG4XrWekCniimh8UrMxeEG0zyha0KfTKDPSQRQ7L1GLM0 kp+vKFOvbOPsDL+xW62KHf0hOQ1nkO9497jqCiwrF8o7VEEtpTv93kzG5N75Uz8R ahJcqH4+863pLeXbmwz9B7J9KwdElLner1JMqpmDROA== 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=btaDgS mOB591jWL9FauawxR9EvMaPH1vS9Fhmr39ScM=; b=UrSO1CVav1nMo907HXaJ5L fqFGcB0URwquDnYTJK0/G3RX/9r6aI5xS8IN2QUd2BjSlBWY82mbI95fXN5iR3tI uZksh2R2vycslbXkuNdZSdF/LmOT+Oe4X9i1fVSn+36QxDDF/w1/lsBe7pf7WOKU t2PUVnFa92l8MmKPl+lTP0eWCjJHV2nWiFSxeEJJWFVLRZBwtWngIla8uac1jBEN iLjhqrvFZrzZ7IPE/iI4OINClXpV7y8Bzj8F8yPIgK9LFdxCxUo78WvUtqJGk6E1 OO9l13WsaippB1CYlQ+AEbtsi0//cnRmyclSr6lBNkBcxLEQLQ6TjLSRBzU4PsCg == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduuddruddtkedguddvudcutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfgh necuuegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmd enucfjughrpeffhffvuffkfhggtggujgesthdtredttddtvdenucfhrhhomheptehnughr vghsucfhrhgvuhhnugcuoegrnhgurhgvshesrghnrghrrgiivghlrdguvgeqnecukfhppe ehtddrudeliedrudeiledrvddujeenucfrrghrrghmpehmrghilhhfrhhomheprghnughr vghssegrnhgrrhgriigvlhdruggvnecuvehluhhsthgvrhfuihiivgeptd X-ME-Proxy: Received: from intern.anarazel.de (50-196-169-217-static.hfc.comcastbusiness.net [50.196.169.217]) by mail.messagingengine.com (Postfix) with ESMTPA id B6CA7103D3; Mon, 20 May 2019 14:00:29 -0400 (EDT) Date: Mon, 20 May 2019 11:00:27 -0700 From: Andres Freund To: Tom Lane Cc: Fujii Masao , Fujii Masao , pgsql-committers@lists.postgresql.org Subject: Re: pgsql: Make VACUUM accept 1 and 0 as a boolean value. Message-ID: <20190520180027.zyxosts5yrf2i7mh@alap3.anarazel.de> References: <26460.1558366996@sss.pgh.pa.us> <20190520163652.l7ibpe52pbq6lecc@alap3.anarazel.de> <20190520164908.t653bdbfjcn3d35p@alap3.anarazel.de> <23559.1558374415@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <23559.1558374415@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hi, On 2019-05-20 13:46:55 -0400, Tom Lane wrote: > Andres Freund writes: > > On 2019-05-21 01:43:35 +0900, Fujii Masao wrote: > >> Thanks for the commit! And sorry, make check-world took very long time > >> and has just finished right now in my env... I'd like to confirm that > >> make check-world reports no error just in case. > > > make -j16 -s && make -Otarget -j10 -s check-world && echo success || echo fail > > > makes that much more bearable, by running the slow TAP tests in > > parallel. Doesn't work < 10 though. Kinda wonder whether we should backpatch the necessary changes to make -j .. check work back to 9.4. > Yeah, parallelization makes all the difference in the world, assuming > you have a multi-core machine. You can parallelize within TAP suites > too. I use > > make -s check-world -j4 PROVE_FLAGS='-j4 --quiet --nocolor --nocount' > > on an 8-core machine, and get typical runtimes under 2m30s. FWIW, I found that parallelizing on the top-level to get better performance than within prove. The system load is more predicatable. > If there were a way to get prove to be absolutely quiet (its --quiet is > a joke unfortunately), I'd lobby for a switch to make pg_regress quiet > too. The amount of useless noise this recipe generates is annoying, > and tends to make it hard to find where the actual error is when > there is one. Indeed. Couldn't we just invent that on our end? I.e. in our prove invocation, just redirect the output? The most annoying noise imo is the pg_upgrade test. The set -x and the fact that it resets MAKEFLAGS makes that pretty annoying. Greetings, Andres Freund