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 1hSp08-0004FV-AN for pgsql-committers@arkaria.postgresql.org; Mon, 20 May 2019 20:35:17 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hSp06-0005AW-BG for pgsql-committers@arkaria.postgresql.org; Mon, 20 May 2019 20:35:14 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hSp04-0005AP-Fn for pgsql-committers@lists.postgresql.org; Mon, 20 May 2019 20:35:14 +0000 Received: from out4-smtp.messagingengine.com ([66.111.4.28]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hSp01-0003Mp-ET for pgsql-committers@lists.postgresql.org; Mon, 20 May 2019 20:35:11 +0000 Received: from compute5.internal (compute5.nyi.internal [10.202.2.45]) by mailout.nyi.internal (Postfix) with ESMTP id 1100524874; Mon, 20 May 2019 16:35:08 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute5.internal (MEProxy); Mon, 20 May 2019 16:35:08 -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=mP3jIdGASkaKg3u31YgTi/zpw4k c+jvDwtzp2MxgXWc=; b=mZFN3w4WeOWco4+3PNlJqocdEfxLOxPQuIWkAa6uZRe QlmWfnUHIv1sSiIofw9Iyd4r7wDdRKVV9Fl1xPojU2RIGqnGEhoCRSQL6DV1WEF7 jDgRJPgmxaRl4Ifzx4BGIS6G1RRwtTGgKS2QxuRsLgim6RcdewNxfPjpi1c6efzx Vtsho5j734X352+RK/ylwCkB+K5IMJjFOnaYThRWXMEzLTRIOtWIFg5dhLpJr30Q w+/V3LR2vYIt5c1RyAE6Ls9Gbgrhw2Y/K3ycHpBnIm8DAIEw2IIuKnF8wDX+Gdj1 VWYL1EXNDNjM5Lrul2B5lIq7aSIu/3BrPgt/ScXbNGQ== 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=mP3jId GASkaKg3u31YgTi/zpw4kc+jvDwtzp2MxgXWc=; b=OJEoo/4gOYbbvCOu5pzctU XvV0O/VT1A4A3bhYiToS70OVVFHlnEo7AnmwnzJsi0CLqKRprj0YrzEpSUYH/dd9 EjcBM6gl/uLP6QZ83wQ+s7vTx/KX9mKla777st5bc/nrIdwCGm42JoO0idt7HJhh Ngb1tInncR3b2BV3W6AiNzw+PzvudSEk4peB+C4BnE9p1SlX5EoF2qB7TLYp5ztU 18PYPgiVuQme42kcZwluzhAM+DUQv1wXMGEcMM1ALJAfLnUHjaNF05mQ01rWzVv0 CZgcqsHnmmIzQDfrJIY1AhB361ECRbP2En0AR03TyKrLQDb4c8sCADx8W2G3d+jw == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduuddruddtkedgudehfecutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfgh necuuegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmd enucfjughrpeffhffvuffkfhggtggujgesthdtredttddtvdenucfhrhhomheptehnughr vghsucfhrhgvuhhnugcuoegrnhgurhgvshesrghnrghrrgiivghlrdguvgeqnecukfhppe dutdegrddvrddugeegrddugeejnecurfgrrhgrmhepmhgrihhlfhhrohhmpegrnhgurhgv shesrghnrghrrgiivghlrdguvgenucevlhhushhtvghrufhiiigvpedt X-ME-Proxy: Received: from intern.anarazel.de (104-2-144-147.lightspeed.sntcca.sbcglobal.net [104.2.144.147]) by mail.messagingengine.com (Postfix) with ESMTPA id 2657180062; Mon, 20 May 2019 16:35:07 -0400 (EDT) Date: Mon, 20 May 2019 13:35:05 -0700 From: Andres Freund To: Tom Lane , Peter Eisentraut , Michael Paquier 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: <20190520203505.zoeitjlehqypgx26@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> <20190520180027.zyxosts5yrf2i7mh@alap3.anarazel.de> <24497.1558375780@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <24497.1558375780@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hi, On 2019-05-20 14:09:40 -0400, Tom Lane wrote: > Andres Freund writes: > > On 2019-05-20 13:46:55 -0400, Tom Lane wrote: > >> 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? > > What I'd like, for both prove and pg_regress, is to print something > about failing tests and otherwise be quiet. Simple redirection won't > do that. Plus it'd be hard to fit that in with the case where you > don't want it to be quiet. Ah, I thought of just doing something roughly (in real syntax etc) like if QUIET_TEST: $(PROVE) $(PROVE_FLAGS) ... > $(CURDIR)/prove.log 2>&1 && echo prove in $CURDIR succeeded || echo prove in $CURDIR failed else $(PROVE) $(PROVE_FLAGS) ... maybe additionally outputting the path to the logfile in the failure case. While far from being as good as what you're desiring, it still seems like it could be a huge improvement over the status quo nevertheless? > > The most annoying noise imo is the pg_upgrade test. The set -x and the > > fact that it resets MAKEFLAGS makes that pretty annoying. > > Agreed, that could be improved independently of other things. Hm, there's a lot of oddities around the pg_upgrade test: 1) we still do an "open coded" install, regardless of dcae5faccab64 And that's *in addition* to to the install from dcae5faccab64. That seems pretty unnecessary. 2) We overwrite MAKELEVEL, MAKEFLAGS, breaking jobserver etc - that shouldn't be required anymore if test.sh were to be changed to behave like dcae5faccab64 3) The fact that src/bin/pg_upgrade/Makefile invokes test.sh with MAKE=$(MAKE) triggers make, for reasons I do not yet understand, to *disable* output synchronization. Which annoys the heck out of me, because it makes parallel check output neigh unparsable. 4) set -x spews a lot of things Greetings, Andres Freund