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.96) (envelope-from ) id 1vVZG6-0058rS-2l for pgsql-hackers@arkaria.postgresql.org; Tue, 16 Dec 2025 17:54:51 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vVZG5-007yYA-2k for pgsql-hackers@arkaria.postgresql.org; Tue, 16 Dec 2025 17:54:50 +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.96) (envelope-from ) id 1vVZG5-007yY2-1n for pgsql-hackers@lists.postgresql.org; Tue, 16 Dec 2025 17:54:50 +0000 Received: from goedel.df7cb.de ([49.13.90.212]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vVZG4-0015Uo-0S for pgsql-hackers@lists.postgresql.org; Tue, 16 Dec 2025 17:54:50 +0000 Received: from msg.df7cb.de (unknown [IPv6:2a02:908:1472:9340:f0ad:fc6e:9c86:f1dc]) by goedel.df7cb.de (Postfix) with ESMTPSA id 2667A46ABD; Tue, 16 Dec 2025 17:54:47 +0000 (UTC) Date: Tue, 16 Dec 2025 18:54:46 +0100 From: Christoph Berg To: Tomas Vondra Cc: Jakub Wartak , pgsql-hackers@lists.postgresql.org Subject: Re: failed NUMA pages inquiry status: Operation not permitted Message-ID: References: <54329add-59b6-4c08-96f0-a025a7804174@vondra.me> <4ff9578d-1de2-45c1-98c4-29caf99334ff@vondra.me> <183fe9ab-6010-4cca-b648-1deca332ce2a@vondra.me> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <183fe9ab-6010-4cca-b648-1deca332ce2a@vondra.me> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Re: Tomas Vondra > 1) right after opening a connection, I get this > > test=# select numa_node, count(*) from pg_buffercache_numa group by 1; > numa_node | count > -----------+------- > 0 | 290 > -2 | 32478 Does that mean that the "touch all pages" logic is missing in some code paths? But even with that, it seems to be able to degenerate again and accepting -2 in the regression tests would be required to make it stable. Christoph