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 1vqahu-00DsKl-3C for pgsql-hackers@arkaria.postgresql.org; Thu, 12 Feb 2026 17:42:28 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vqahu-00AFZ3-0g for pgsql-hackers@arkaria.postgresql.org; Thu, 12 Feb 2026 17:42:27 +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 1vqaht-00AFXn-2c for pgsql-hackers@lists.postgresql.org; Thu, 12 Feb 2026 17:42:26 +0000 Received: from meesny.iki.fi ([195.140.195.201]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1vqahr-00000000M1X-1UfB for pgsql-hackers@lists.postgresql.org; Thu, 12 Feb 2026 17:42:26 +0000 Received: from [10.0.2.15] (unknown [130.41.208.2]) (using TLSv1.3 with cipher TLS_AES_128_GCM_SHA256 (128/128 bits) key-exchange x25519 server-signature RSA-PSS (2048 bits) server-digest SHA256) (No client certificate requested) (Authenticated sender: hlinnaka) by meesny.iki.fi (Postfix) with ESMTPSA id 4fBjL50m2pzyNR; Thu, 12 Feb 2026 19:42:21 +0200 (EET) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=iki.fi; s=meesny; t=1770918142; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references; bh=vCU5HexjgOIYjbN/a93SyRST14WZVKmN7F3WPkUHq7w=; b=TkJDU8urPmdalW4EbS/x1OCXVPAd1h8B0YkqaT2kVedkC3inLzvrjXDzhWgiyWmDZS41Fg kizwOwf0MTAZilpyZSizAIgdu5k4QvooalChoIKIV23Ngh6hXobDwLO9Zc/ya+u5L7IkqI 9G+unY3vSGRbX9TboAX2ivr1mVU9OfQ= ARC-Seal: i=1; a=rsa-sha256; d=iki.fi; s=meesny; cv=none; t=1770918142; b=hZLXW+cqcGkJgwEC+48jDGsxemx0uqNCoY4zIG5TQeDbCfyjTY7ebZaVSX++FPNCZ2s/Ux AmopezlEUw1qkvRiRzS1y0vsPMwg7f96FRlIOZ57mJRwYr5WIj6+xZeSNAPBGtySkXZKtD Kc4Y80pEWrhyAq+p0bGhKtKmgPFDVm0= ARC-Authentication-Results: i=1; ORIGINATING; auth=pass smtp.auth=hlinnaka smtp.mailfrom=hlinnaka@iki.fi ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=iki.fi; s=meesny; t=1770918142; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references; bh=vCU5HexjgOIYjbN/a93SyRST14WZVKmN7F3WPkUHq7w=; b=cM+VPauPz7Wg9VKaKwcFzS+/MN5H0eDGQxXK9Pz295yzUkC9LM/Bmr1SGErd25klbYxUuz 0fHew2gSN3TagwbtHZh1gfPdbQRfZofELqx68685TPC3bF6Gja7gnBqk9Q+xQpWfGLzhsA 9CO08QXBm/8oSgXCAvXG6C4QWUIEkFM= Message-ID: <0aac5d44-0063-458d-8792-e9bbbc37fe72@iki.fi> Date: Thu, 12 Feb 2026 19:42:20 +0200 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: pgsql: Introduce pg_shmem_allocations_numa view To: Bertrand Drouvot , =?UTF-8?Q?=C3=81lvaro_Herrera?= Cc: Tomas Vondra , Christoph Berg , Andres Freund , Tomas Vondra , pgsql-hackers@lists.postgresql.org References: <21cc7a48-99d9-4f69-9a3f-2c2de61ac8e5@iki.fi> <202602121635.kdy5xdbvxaqi@alvherre.pgsql> Content-Language: en-US From: Heikki Linnakangas In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 12/02/2026 19:23, Bertrand Drouvot wrote: > Hi, > > On Thu, Feb 12, 2026 at 05:43:47PM +0100, Álvaro Herrera wrote: >> On 2026-Feb-12, Heikki Linnakangas wrote: >> >>> I just noticed that this (commit bf1119d74a: Add CHECK_FOR_INTERRUPTS into >>> pg_numa_query_pages) made the function unusable in frontend programs, >>> because CHECK_FOR_INTERRUPTS is server only. > > Good catch! Out of curiosity how did you find the issue? Were you building a > client tool making used of pg_numa_query_pages()? I was working on my "interrupts vs signals" patch, which needed to change some #includes in pg_numa.c, when I spotted that it already had that issue. >> It's not used in frontend >>> programs today, but it was placed in src/port/ with the idea that it could >>> be. >> >> Your patch LGTM. > > +1 Pushed, thanks! - Heikki