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 1soucW-00Ek1Z-BF for pgsql-hackers@arkaria.postgresql.org; Fri, 13 Sep 2024 00:57:09 +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 1soucV-005V29-69 for pgsql-hackers@arkaria.postgresql.org; Fri, 13 Sep 2024 00:57:07 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1soucU-005V21-S4 for pgsql-hackers@lists.postgresql.org; Fri, 13 Sep 2024 00:57:06 +0000 Received: from mail-il1-x129.google.com ([2607:f8b0:4864:20::129]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1soucO-000swR-6y for pgsql-hackers@postgresql.org; Fri, 13 Sep 2024 00:57:05 +0000 Received: by mail-il1-x129.google.com with SMTP id e9e14a558f8ab-39d47a9ffb9so5666185ab.1 for ; Thu, 12 Sep 2024 17:57:00 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1726189019; x=1726793819; 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=XbNE6KKAKEKXmjBlZLxUF+SNYvw9/Thng+Drus2taxE=; b=RTLepVgreT5NdokjSfjZ22j2WCtUw20Z4+H2qzusdE42Sx0ush0rUczYBDezJw+Cdu XCYM6uV0qf1M+wgl1CEIKUdx3cgYhYY85/u97oYag9uHp4fCClOUoDBNjbJ4Ralc7v+1 2TCxzQnmvn2xka7Ju33wKy5OJCq2yEwpEvCpr/m0f+D9ZuFuuWUAQgt+KdA2SjcXNmNe UdlyLzq2ssAA5DtwatfPkufPc+J8MewnHZaG8UU2wDmQZVvSeQwxTs6Ki2hY4Y1JCUZh IRTTPigC4NV3Y6hq26qxEmpXctDkpoHdXJAq9CQ7sPe/1QLehjbwJf5zPeA/KG5NPsbn wzqA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1726189019; x=1726793819; 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=XbNE6KKAKEKXmjBlZLxUF+SNYvw9/Thng+Drus2taxE=; b=ctK3doe9xlyXv7wSM2QuwnjMe5Tc6nEpMzujaqiif6FsJN20z0O0EbW4tlnbvu2Bl9 6UlQaCzmdunriVAAGWdIVikhUd5zMuTUMGaBl5H4sr7CUc3jiuzFBRu4SzkavjNEOxk2 Hr+UVbwARc3pGY8ojEXfFOcYkhx7NvwXea8BJa3kv938lnmazitz+NtZ8g2x5q8hz53Q uMwaVRcMLT/WOrNjDMxTg3hgKJmoq9a5EksYLMYvVSOjhMBHJjf2C97169oG8GUwPANX GxvY/a7ZoVnW99SZOfM0yr82TAn+/Z7c2XHAOyO3YFESAY7kIl/khBL7F+XxDhvdIP4w 9ZTQ== X-Forwarded-Encrypted: i=1; AJvYcCXYFaRi3dC+u7cmup5e2uFBnX/nzni27gLLbRJsvR/RmGMYT/xKr2tl/jGgjFsP7Axs0uUIQnmkNpzkpMG2@postgresql.org X-Gm-Message-State: AOJu0YxefzspcMsmaUE2klEBMCx7CDhaW0v7mxQSICG0fMcEJbPcFSZp f41mY6HKVyTQ4kn65D5DU9KcYSKlbZVNErnsCaFOUWMcUI2b2yMdTf7NAQ== X-Google-Smtp-Source: AGHT+IELlulddt/d1xo9jdSQyLm9CQrQ7I+7NfICnfKw/cMKJ9iYEUGMGGIMHiG9OGZ9tutF/1lpsA== X-Received: by 2002:a05:6e02:13a6:b0:398:39f:8b4d with SMTP id e9e14a558f8ab-3a0848e54afmr49213675ab.5.1726189019504; Thu, 12 Sep 2024 17:56:59 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id e9e14a558f8ab-3a05900e293sm34589225ab.64.2024.09.12.17.56.58 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 12 Sep 2024 17:56:58 -0700 (PDT) Date: Thu, 12 Sep 2024 19:56:56 -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 Fri, Sep 13, 2024 at 09:47:36AM +0900, Michael Paquier wrote: > On Thu, Sep 12, 2024 at 07:41:30PM -0500, Nathan Bossart wrote: >> Ugh, the buildfarm is unhappy with the new tests [0] [1]. Will fix. > > I'd suggest to switch the test to return a count() and make sure that > one record exists. The data in the page does not really matter. That's what I had in mind. 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... -- nathan