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 1vqaPz-00DltI-0H for pgsql-hackers@arkaria.postgresql.org; Thu, 12 Feb 2026 17:23:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vqaPy-00A6Vf-0Q for pgsql-hackers@arkaria.postgresql.org; Thu, 12 Feb 2026 17:23:54 +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 1vqaPx-00A6VX-2U for pgsql-hackers@lists.postgresql.org; Thu, 12 Feb 2026 17:23:54 +0000 Received: from mail-wm1-x32d.google.com ([2a00:1450:4864:20::32d]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vqaPw-00000000LrC-0X1f for pgsql-hackers@lists.postgresql.org; Thu, 12 Feb 2026 17:23:54 +0000 Received: by mail-wm1-x32d.google.com with SMTP id 5b1f17b1804b1-4806ce0f97bso844875e9.0 for ; Thu, 12 Feb 2026 09:23:52 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1770917031; x=1771521831; darn=lists.postgresql.org; h=in-reply-to:content-transfer-encoding:content-disposition :mime-version:references:message-id:subject:cc:to:from:date:from:to :cc:subject:date:message-id:reply-to; bh=u6y5Z9fTRmJy4WIkrG90qhUzA4Y3QxDVaFskCkwTYak=; b=ZJPoeVpC8KFSmti3s71EUZGm7hC8kTHyG4dJwlNnzQb+nc0FAyf1u/03R8BCxw2RrY z9EepZZtScDEn1CGYAJe/8Hosnfg846Gyng3fqc4w9QvNk3jeF25UhBwSWzG900KQ2dT HxZBBEVoVHGzuO4PZotI0szuXmtqK/4PmYDg5AvVm81N1Kh3ywPVwO+cJapesxdHu3Qz gCtwH2xcxifLpYgwQJeDLXACWBVKLa7Odjq0gIr1tuzXidCA6xyiUqw2HfHqueNd6Yfz 8mKKioTJg/UYXHHaGhhXcE6PUHuELAQTVlq9yi9ICPykawM2qFh4HZqpGCgE6a2dB/7d UeTw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1770917031; x=1771521831; h=in-reply-to:content-transfer-encoding:content-disposition :mime-version:references:message-id:subject:cc:to:from:date:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=u6y5Z9fTRmJy4WIkrG90qhUzA4Y3QxDVaFskCkwTYak=; b=ZPX0LIAONyZ0va2ivoCjZaLqaazrbgZUC8U0StvP//TGu2VEylEgCkpvYvFZTfPPQB Z+RMsPhW0/iZti2vNCPSBzeyci1olw4jdAN5ib0gVfrEUrWDDuYKUio/pD20SUkeDneE f1HVxafg32FjKPW0Lx0/CCXYoOu41cYA7Mb/ccqcqq8Su6d1Lu/4Sx4aEOpR9Qn2iGKk mpjoubPBx1gG1uufzwS7M1eBDQPN5z3mEEFIxRiyCiaZulD5UoFrxEJfnXB98uGXeM0c H3i6Wv+Fws2xdwedKEk0OOn259k0oDnt6iilg/p0fqfr9gfyhrQQvZMSTLGDbEp4QeMw KZmQ== X-Forwarded-Encrypted: i=1; AJvYcCX8JKhhJ0WEXvrHi0Up48Ef0o05OBiyOycRNX6Bjei5fgPeLWljN1Z1bzx54FNE6enr3lKjgwqO90SKNtBH@lists.postgresql.org X-Gm-Message-State: AOJu0YxBS2v30YrtbZNorVyg0c+mll7a51kJjxKUzR9pI9yagRfWqlEm T3xCsO00qsYn3GRuW7H80I/RwWodMfeRxhdnmxGazT4CcviM9kdELSmd X-Gm-Gg: AZuq6aJVC/WOcReV4EiDNvaG4CQtfmujPDGWu2o6ERn8JAjKyuC2SeZlkFPxeuVl3G5 E3j7WZduY+FX0OWfLac0svxqEl6aZh4UIWqWEdtk7lFGZnZ5uWik5P4kVAbRO4RfXtgZuQsxcVs 9ZONcyLfn+bBd0J0JqYTVHnA1+4NtBZDjfLW/WgyPIuW/fiLQ1YKtCpExfI7NR/Dk5OHlsgRcTQ FExf43Gyo67Ar4U0wAUsxVx38KkXdTuiMR/P13D3ZPPClVM6lFV38ylXDRbVunZJSH175A772ER /s0Pyr3+2gX7gYeQ/NmotWyWC5IRya8UXbQDyfQy/tGOaMoP+0+keSBPUFR5cHuCITRZuafny5s TaGJmXjqnsG/8E+YjsA8gRc1+Bp5TaATTrfhgHH4c/p44AOzyPibg95G3vZy9hk2blq9kUrS/pC eI5V22vwPj36Z9H5SY7kXZ4EkRyHhkfnTnbfUvjbo36LnxLWB26C+2AK0hC31zzZGm3a3FvXejp suae+AsMrI0zu7h5FWtfpXvlvWIzvC/Rso1O76RyAh3IuBP83tOQJbdkw== X-Received: by 2002:a05:600c:3f06:b0:477:73e9:dc17 with SMTP id 5b1f17b1804b1-4836717f09fmr48458775e9.35.1770917030872; Thu, 12 Feb 2026 09:23:50 -0800 (PST) Received: from ip-10-97-1-34.eu-west-3.compute.internal (ec2-15-237-197-144.eu-west-3.compute.amazonaws.com. [15.237.197.144]) by smtp.gmail.com with ESMTPSA id 5b1f17b1804b1-483709f89aasm179645e9.1.2026.02.12.09.23.50 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 12 Feb 2026 09:23:50 -0800 (PST) Date: Thu, 12 Feb 2026 17:23:49 +0000 From: Bertrand Drouvot To: =?iso-8859-1?Q?=C1lvaro?= Herrera Cc: Heikki Linnakangas , Tomas Vondra , Christoph Berg , Andres Freund , Tomas Vondra , pgsql-hackers@lists.postgresql.org Subject: Re: pgsql: Introduce pg_shmem_allocations_numa view Message-ID: References: <21cc7a48-99d9-4f69-9a3f-2c2de61ac8e5@iki.fi> <202602121635.kdy5xdbvxaqi@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <202602121635.kdy5xdbvxaqi@alvherre.pgsql> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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()? > 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 Regards, -- Bertrand Drouvot PostgreSQL Contributors Team RDS Open Source Databases Amazon Web Services: https://aws.amazon.com