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 1nfBZh-0001V6-Ui for pgsql-hackers@arkaria.postgresql.org; Fri, 15 Apr 2022 02:20:41 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nfBZf-0001XR-Dg for pgsql-hackers@arkaria.postgresql.org; Fri, 15 Apr 2022 02:20:39 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nfBZf-0001XI-3y for pgsql-hackers@lists.postgresql.org; Fri, 15 Apr 2022 02:20:39 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nfBZc-0003L1-SS for pgsql-hackers@lists.postgresql.org; Fri, 15 Apr 2022 02:20:38 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 23F2KTUu1574962; Thu, 14 Apr 2022 22:20:30 -0400 From: Tom Lane To: Peter Geoghegan cc: Andres Freund , Noah Misch , David Rowley , PostgreSQL Hackers Subject: Re: Intermittent buildfarm failures on wrasse In-reply-to: References: <1364997.1649893086@sss.pgh.pa.us> <1365924.1649893883@sss.pgh.pa.us> <1374062.1649896550@sss.pgh.pa.us> <20220414010505.s7z24jxrfsjbzz7l@alap3.anarazel.de> <1401379.1649899392@sss.pgh.pa.us> <20220414015112.yhruzx3dbjnz4pji@alap3.anarazel.de> <20220414025122.GA808845@rfd.leadboat.com> <1486022.1649952083@sss.pgh.pa.us> <20220414161850.ibqkevxcv6a7vdxg@alap3.anarazel.de> <1521388.1649953580@sss.pgh.pa.us> <1547912.1649971995@sss.pgh.pa.us> <1553951.1649975018@sss.pgh.pa.us> <1570894.1649986347@sss.pgh.pa.us> <1572437.1649987614@sss.pgh.pa.us> Comments: In-reply-to Peter Geoghegan message dated "Thu, 14 Apr 2022 18:59:14 -0700" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <1574960.1649989229.1@sss.pgh.pa.us> Date: Thu, 14 Apr 2022 22:20:29 -0400 Message-ID: <1574961.1649989229@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Peter Geoghegan writes: > That was the intent, but that in itself doesn't mean that it isn't > something to do with setting hint bits (not the OldestXmin horizon > being held back). Oh! You mean that maybe the OldestXmin horizon was fine, but something decided not to update hint bits (and therefore also not the all-visible bit) anyway? Worth investigating I guess. > I'd really like to know what the removable cutoff > looks like for these VACUUM operations, which is something like > Andres' VACUUM VERBOSE debug patch should tell us. Yeah. I'd hoped to investigate this manually and not have to clutter the main repo with debugging commits. However, since I've still utterly failed to reproduce the problem on wrasse's host, I think we're going to be forced to do that. regards, tom lane