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 1nfPY5-0005a2-Fz for pgsql-hackers@arkaria.postgresql.org; Fri, 15 Apr 2022 17:15:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nfPY4-0006IC-Bd for pgsql-hackers@arkaria.postgresql.org; Fri, 15 Apr 2022 17:15:56 +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 1nfPY4-0006I3-2a for pgsql-hackers@lists.postgresql.org; Fri, 15 Apr 2022 17:15:56 +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 1nfPY2-0002l5-4n for pgsql-hackers@lists.postgresql.org; Fri, 15 Apr 2022 17:15:55 +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 23FHFnjT1653800; Fri, 15 Apr 2022 13:15:49 -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: <1570894.1649986347@sss.pgh.pa.us> <20220415015249.kfsqxujrf2bn2wz6@alap3.anarazel.de> <20220415024515.GA862547@rfd.leadboat.com> <20220415051205.6abhlilh6fnjgohr@alap3.anarazel.de> <20220415052125.GD862547@rfd.leadboat.com> <1637671.1650032132@sss.pgh.pa.us> <1643035.1650035653@sss.pgh.pa.us> <20220415170542.hkwqvyshhg2bjfcd@alap3.anarazel.de> Comments: In-reply-to Peter Geoghegan message dated "Fri, 15 Apr 2022 10:11:03 -0700" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <1653798.1650042949.1@sss.pgh.pa.us> Date: Fri, 15 Apr 2022 13:15:49 -0400 Message-ID: <1653799.1650042949@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Peter Geoghegan writes: > On Fri, Apr 15, 2022 at 10:05 AM Andres Freund wrote: >> The other shows >> the age of OldestXmin at the end of the vacuum. Which is influenced by >> what's currently running. > As well as the age of OldestXmin at the start of VACUUM. Is it worth capturing and logging both of those numbers? Why is the age at the end more interesting than the age at the start? regards, tom lane