Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sovKD-00EpIM-Fi for pgsql-hackers@arkaria.postgresql.org; Fri, 13 Sep 2024 01:42:18 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sovKC-006T7g-TV for pgsql-hackers@arkaria.postgresql.org; Fri, 13 Sep 2024 01:42:16 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sovKC-006T7Y-I2 for pgsql-hackers@lists.postgresql.org; Fri, 13 Sep 2024 01:42:16 +0000 Received: from mail-io1-xd34.google.com ([2607:f8b0:4864:20::d34]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sovK9-000uJ5-3b for pgsql-hackers@postgresql.org; Fri, 13 Sep 2024 01:42:15 +0000 Received: by mail-io1-xd34.google.com with SMTP id ca18e2360f4ac-82a626d73efso62125739f.1 for ; Thu, 12 Sep 2024 18:42:14 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1726191732; x=1726796532; darn=postgresql.org; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:from:to:cc:subject:date:message-id:reply-to; bh=Q1rK6rNJbW8KdvFHSYOAH2kLSdwKkcKriqCIycm4Hi0=; b=DJCqCTzpFdgRBMOuS/q2HFd3dHf3Abxmsw4hEysi/wPYE/brtu5sC4z7k5sRs89E7Q OXcYPKAOt0x2V4iNkSxucuzNUWrRwRNCSTvxFXQ/lP2GE4ryJZg7NUK9YIIAQYvwr8t/ 5eepUd340zF1KVBO19RaeO8qhiBQgAzdb3NeTEUlpV7pwVGgTb/p2NzqGUntE4V6IYEB MIBtqfsbi8/XhdX2z7JLbHUHdRw2WnudsnkmnrvgnEjWxM1CtS7cp9myTWrr8FK3j0GG adfi9+LsFeq4hdFBNFp2npjdTz/mt85pJo0ZXiJxqN6ypRtPFa3+S6E1CSW6w2lDBuXi VUTA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1726191732; x=1726796532; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=Q1rK6rNJbW8KdvFHSYOAH2kLSdwKkcKriqCIycm4Hi0=; b=DIN2yHlhRJGLjRVyAmYwuvS+GhsoGswsRDetGdFav7wolm0H32hVD7QhND4KSEwv9J GFIGAS+3K96sXZM2dmQixRCGbgzuZLcqM6XBYA4MD1xl8uPuNC65NBoMMjqnzz4laCYA n6Apx5pX9XSpfkSPW3ZA/ZjvwF0uVImlnT26lKbCQDF1SnkqiDX89JPGy9S5jMX5YdbE X0N/H1sAgXgLBbAoy7NDFvB6HlDXV9kx7pi6bE8iSH8fZT71DX3x7mevPDOOsESKQUyl 5ORtyfwTR9zmvL+7vVZd1go2XF1QleLKfp/2HYecymh90W5SBUuhrc1LzXlRa3viPDe4 5kkA== X-Forwarded-Encrypted: i=1; AJvYcCUgzseZd/zL+cXcXYgvkmcmQOYcAmePsB7hQK+3oXRT4gz9fB8/QDqjwZFmSF/gIIMIHEO6hf1OYCSGEh7h@postgresql.org X-Gm-Message-State: AOJu0Yw+bq0fDh/qXEpQ/Gesk/UAprwITWBrqGBbbzwoDwnBYKTjO6jO Zcr+izplC1TBnaVeJRoUI0ghESXCzzkiQyIaL8bRonW2xNOgTKmj X-Google-Smtp-Source: AGHT+IESFlHDIq0R3QjpsPJD38c1OG7OWzeQkzQpbWrA1+nye/A4qh/x7amomEXpXtal+FhTwvgxKg== X-Received: by 2002:a05:6602:1495:b0:806:31ee:132 with SMTP id ca18e2360f4ac-82d1f8e3c96mr497489539f.4.1726191732577; Thu, 12 Sep 2024 18:42:12 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id ca18e2360f4ac-82aa713d3edsm335733239f.0.2024.09.12.18.42.11 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 12 Sep 2024 18:42:11 -0700 (PDT) Date: Thu, 12 Sep 2024 20:42:09 -0500 From: Nathan Bossart To: Michael Paquier Cc: Matthias van de Meent , Robert Haas , Ayush Vatsa , PostgreSQL Hackers Subject: Re: Pgstattuple on Sequences: Seeking Community Feedback on Potential Patch Message-ID: References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, Sep 12, 2024 at 07:56:56PM -0500, Nathan Bossart wrote: > I see that skimmer is failing with this error: > > ERROR: cannot access temporary tables during a parallel operation > > This makes sense because that machine has > debug_parallel_query/force_parallel_mode set to "regress", but this test > file has used a temporary table for a couple of years without issue... Oh, the answer seems to be commits aeaaf52 and 47a22dc. In short, we can't use a temporary sequence in this test for versions older than v15. -- nathan