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 1hpfgT-0000Wb-Ar for pgsql-hackers@arkaria.postgresql.org; Mon, 22 Jul 2019 21:17:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hpfgR-000095-4S for pgsql-hackers@arkaria.postgresql.org; Mon, 22 Jul 2019 21:17:23 +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 1hpfgQ-000050-Pw for pgsql-hackers@lists.postgresql.org; Mon, 22 Jul 2019 21:17:22 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hpfgN-0004Ke-6s for pgsql-hackers@lists.postgresql.org; Mon, 22 Jul 2019 21:17:22 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id x6MLHFTx019064; Mon, 22 Jul 2019 17:17:15 -0400 From: Tom Lane To: Alvaro Herrera cc: pgsql-hackers@lists.postgresql.org, Manuel Rigger Subject: Re: Broken defenses against dropping a partitioning column In-reply-to: <20190722193459.GA14241@alvherre.pgsql> References: <20190722193459.GA14241@alvherre.pgsql> Comments: In-reply-to Alvaro Herrera message dated "Mon, 22 Jul 2019 15:34:59 -0400" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <19062.1563830235.1@sss.pgh.pa.us> Date: Mon, 22 Jul 2019 17:17:15 -0400 Message-ID: <19063.1563830235@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Alvaro Herrera writes: > On 2019-Jul-22, Tom Lane wrote: >> I nearly missed the need for that because of all the noise that >> check-world emits in pre-v12 branches. We'd discussed back-patching >> eb9812f27 at the time, and I think now it's tested enough that doing >> so is low risk (or at least, lower risk than the risk of not seeing >> a failure). So I think I'll go do that now. > I'd like that, as it bites me too, thanks. Done. The approach "make check-world >/dev/null" now emits the same amount of noise on all branches, ie just NOTICE: database "regression" does not exist, skipping The amount of parallelism you can apply is still pretty branch-dependent, unfortunately. regards, tom lane