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 1mb8DR-0006kk-Td for pgsql-hackers@arkaria.postgresql.org; Thu, 14 Oct 2021 21:24:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mb8DQ-0007Wl-Ka for pgsql-hackers@arkaria.postgresql.org; Thu, 14 Oct 2021 21:24:40 +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 1mb8DP-0007W5-WA for pgsql-hackers@lists.postgresql.org; Thu, 14 Oct 2021 21:24:40 +0000 Received: from mail-pf1-x434.google.com ([2607:f8b0:4864:20::434]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mb8DN-0007Nn-Fx for pgsql-hackers@postgresql.org; Thu, 14 Oct 2021 21:24:38 +0000 Received: by mail-pf1-x434.google.com with SMTP id o133so6580627pfg.7 for ; Thu, 14 Oct 2021 14:24:36 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; h=mime-version:subject:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to; bh=mTY+0t8MQ4PdchRZ+n5d4rWCzXAUMf0coMmFOTxxRoQ=; b=GJc+difjS+b9xhlOCXGDClBJeT42/EEHvEb+Kkx+f+itSzNO1tS9THhtfajPvCrjeE wlHv5ESepnujxRVBHIjs9NcliVrgSyxL7VVusAmGNIsEcuAEPt0mITTb8m/jkcg0yWEq FR92UQkJaCprauyo71FRL1WLzMn/BnSwkDZt/GtpNBY0Gl6tgllafHzXJ9tHWpr1NZ/1 WujjFDbRItgZdCPmaXoYhh2loRs3EdGHPQ9yh24CPIdlKWQSrBGMsyv91fPr9ogaamfy /+RN0ai6VeiTToBaeFgExx8rNVXP3UhvdOdFSRzcIJi4yY0DDsnZnvy3lEuZzjGDWint MwuQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:subject:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to; bh=mTY+0t8MQ4PdchRZ+n5d4rWCzXAUMf0coMmFOTxxRoQ=; b=PF3qyHS4E417x/9uj8k4XrldZgl0+dvFWkzTZ/aOkwbBTz5EdeMbHMaZ/8+iOTv7J0 +QEBMShC6hCwXjNtgCHOHWVeSrEaQwkcrsPMdeNZuWOYLV/ulRWKNUK8njEU6b7hLdid oyCNsmqktAp3r6B0GoG3UpBXEk4ZWZlWsQuf2JLoemf7OSMIdLqQNnBpp6u/qXBy3wLb V1Xz+ryn4l+2kZmRmmirq43921U3J51dWPnxZjOKPvwCJUcE+DO9nGpyoFZ6yzSQFxre 0uZ3pzfP3oFqp4i9cuslsIwaevSmpExA4l7A6iDLXuXiUGs0K7pxq0EhZSYP4fnjDt0D 3nww== X-Gm-Message-State: AOAM533WN2mBcRC5YiPWK4VHzTILQ/LV2SM21mSi4vDM1sbd7F6rgwTx rOKaA7mYktYzf1Dik5ISn5mSrNDLW+WwpDkrwZWXAV6jkPalmYqqzyO//H8tiPuxW5/VvBRkIqf BhiJGsJ79mZNPPNze+XZtFyZREE5LB627u+OAyeimDyQgnNoiS7hLmtA3LA+NO47TTe4k/3xB3T 2WkTCbYWnBUfNC8QXK6zBgmg0DDikdH5TmPXuK X-Google-Smtp-Source: ABdhPJzsrvrWZcLniYv0Vu5x9Rvs5tzEOeyUCXTIAXgwF4aJcFLmvHOtx98ePsS1FQO19au/eZg5QA== X-Received: by 2002:a63:15:: with SMTP id 21mr6128228pga.479.1634246675518; Thu, 14 Oct 2021 14:24:35 -0700 (PDT) Received: from laptop280-ma-us.hitronhub.home (24-113-193-150.wavecable.com. [24.113.193.150]) by smtp.gmail.com with ESMTPSA id e6sm3276456pfm.212.2021.10.14.14.24.34 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Thu, 14 Oct 2021 14:24:35 -0700 (PDT) Content-Type: text/plain; charset=utf-8 Mime-Version: 1.0 (Mac OS X Mail 13.4 \(3608.120.23.2.7\)) Subject: Re: BUG #17212: pg_amcheck fails on checking temporary relations From: Mark Dilger In-Reply-To: Date: Thu, 14 Oct 2021 14:24:33 -0700 Cc: Tom Lane , Andrew Dunstan , Robert Haas , Pavel Borisov , Alexander Lakhin , PostgreSQL-development Content-Transfer-Encoding: quoted-printable Message-Id: References: <17212-34dd4a1d6bba98bf@postgresql.org> <543F3BF3-EDED-4C52-AF05-623921B6C409@enterprisedb.com> <55A2BFE7-AAAF-4A64-BD3A-5C98EA982267@enterprisedb.com> <40DB088B-C96F-49B2-BC84-BDC8D35C7E97@enterprisedb.com> <0B7DA7A4-2872-485B-BFDD-BF8E9BB07B26@enterprisedb.com> <726473.1634184950@sss.pgh.pa.us> <02C6345B-D186-4F88-A976-A2CD1051CB93@enterprisedb.com> <903680.1634246015@sss.pgh.pa.us> To: Peter Geoghegan X-Mailer: Apple Mail (2.3608.120.23.2.7) X-CLOUD-SEC-AV-Info: enterprisedb,google_mail,monitor X-CLOUD-SEC-AV-Sent: true X-Gm-Spam: 0 X-Gm-Phishy: 0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On Oct 14, 2021, at 2:21 PM, Peter Geoghegan wrote: >=20 > I agree. I can go remove the whole file now, and will. >=20 > Mark: Any objections? None of the "pride of ownership" type, but I would like to see something = more about the limitations of background_psql(). It's the closest thing = we have to being able to run things in parallel from TAP tests. There's = no isolationtester equivalent, and PostgresNode doesn't allow you to = fork() in tests without hacking PostgresNodes END{} block. So if we = don't debug this, we never get any further towards parallel testing from = perl. Or do you have a different way forward for that? =E2=80=94 Mark Dilger EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company