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 1sjj6X-003MiP-0o for pgsql-hackers@arkaria.postgresql.org; Thu, 29 Aug 2024 17:38:41 +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 1sjj6V-005DV1-14 for pgsql-hackers@arkaria.postgresql.org; Thu, 29 Aug 2024 17:38:39 +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 1sjj6U-005DUt-ME for pgsql-hackers@lists.postgresql.org; Thu, 29 Aug 2024 17:38:39 +0000 Received: from mail-il1-x133.google.com ([2607:f8b0:4864:20::133]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sjj6S-00236C-Lg for pgsql-hackers@postgresql.org; Thu, 29 Aug 2024 17:38:38 +0000 Received: by mail-il1-x133.google.com with SMTP id e9e14a558f8ab-39d311d8091so3436795ab.3 for ; Thu, 29 Aug 2024 10:38:36 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1724953116; x=1725557916; 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=4nBNPr+CU2fzhT9wkH42YJzhXtMp82a2DFunFq6EwDE=; b=QHr9dhm1ryvbBC6IIPSnWqy6naedrZ8eJMOfEYhpFzQ8i8UbKQgc2opMD6E0tJ2UGu cWS4rfUdZxko0rNae6xyQTBo52FmF/ksTd0ZsiIz2RIB+l5Y3SMhqmTwF8MGhGb6mfwl qrI5N2PsypwV/dnigXYiBcPLxkMz6ZmW3oZ/4rdJ8CJfktf++2o81JUoXb50SU4SUXsh kvSGrll11VWRssMRD3dhgT7zepnLV+oM0hCiZHi74EBQteZ0sIuDf8Ex0tWaxzZwOl+x DTBhfEzYu3oYz7oMDXB1AVTS7FFF/5ZJ11SAOksBck+DAe8mb5kwdbtekrN2dh/8mTAa bnGQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1724953116; x=1725557916; 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=4nBNPr+CU2fzhT9wkH42YJzhXtMp82a2DFunFq6EwDE=; b=Wx4wcxJE7oRAPyanON0N5tsfXqNFb/U4NpYysVMY1nT80o0vHlsZh8Zv55xIC3N/P6 UazQFzNjrpYPGv+BYmIFKLDtk93FCEreE0HcmnlYLuGbtW1AEkbu7BVfdGsQy0oO8j8M 6an2aX6d3Bd01o7IE8JOI8eqygY4a81o2cqygjqVWX6Zir8/TesgOXJ37LR+UOTGUq7V uqy6VC/9SogYxrPLUd+S381PYwZkD14CH5EA3J7hd8wa+WkgZpKgP0sdJqpKgreUw5Nh mWkNjZOMUIDgdVhxWuNB3nkeb0zq5FWVAT5sib7WQZHIUExOqCJ2Lp/+3mWcDY/HLKj0 8FzA== X-Forwarded-Encrypted: i=1; AJvYcCW/IDXv5+vWUOZkVNTlSpYTkWHkPYS13IUI/o155hsBPve+PCuP6wkxDLYIfZVt8myLldTQ4Eg0U0zLw4vS@postgresql.org X-Gm-Message-State: AOJu0Yxy20IwaWTO20HiWp6z5P9zmG5SBgy2evBGuT5t344GT2hUmk2V 7u7PpeKe4fjvy5qiwkojZHs7hghes7+C2J5oTE9N8jEkEd8vBjzSHm8sig== X-Google-Smtp-Source: AGHT+IHsugnO6+mDzImzPL1Yu8DVFbbZwxAL+cydMXh57kiu4Uy9phJ9i62Ggb09ag0MN0cAvGWxnQ== X-Received: by 2002:a05:6e02:1787:b0:382:b82b:6e48 with SMTP id e9e14a558f8ab-39f377e0987mr46342425ab.9.1724953115697; Thu, 29 Aug 2024 10:38:35 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id 8926c6da1cb9f-4ced2eabdd2sm328680173.130.2024.08.29.10.38.35 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 29 Aug 2024 10:38:35 -0700 (PDT) Date: Thu, 29 Aug 2024 12:38:33 -0500 From: Nathan Bossart To: Ayush Vatsa Cc: Robert Haas , PostgreSQL Hackers , michael@paquier.xyz 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, Aug 29, 2024 at 12:36:35PM -0500, Nathan Bossart wrote: > +select * from pgstattuple('serial'); > + table_len | tuple_count | tuple_len | tuple_percent | dead_tuple_count | dead_tuple_len | dead_tuple_percent | free_space | free_percent > +-----------+-------------+-----------+---------------+------------------+----------------+--------------------+------------+-------------- > + 8192 | 1 | 41 | 0.5 | 0 | 0 | 0 | 8104 | 98.93 > +(1 row) > > I'm concerned that some of this might be platform-dependent and make the > test unstable. Perhaps we should just select count(*) here. Sure enough, the CI testing for 32-bit is failing here [0]. [0] https://api.cirrus-ci.com/v1/artifact/task/4798423386292224/testrun/build-32/testrun/pgstattuple/regress/regression.diffs -- nathan