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 1uYnBW-00BXXr-IK for pgsql-hackers@arkaria.postgresql.org; Mon, 07 Jul 2025 14:51:10 +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 1uYnBU-002x25-Lu for pgsql-hackers@arkaria.postgresql.org; Mon, 07 Jul 2025 14:51:09 +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 1uYnBU-002x1m-CV for pgsql-hackers@lists.postgresql.org; Mon, 07 Jul 2025 14:51:09 +0000 Received: from mailfr00.databene.net ([31.170.12.19]) by makus.postgresql.org with smtp (Exim 4.96) (envelope-from ) id 1uYnBR-0063RT-3B for pgsql-hackers@lists.postgresql.org; Mon, 07 Jul 2025 14:51:08 +0000 Received: from localhost (localhost.localdomain [127.0.0.1]) by mailfr00.databene.net (Postfix) with ESMTP id DA22D5F2D0; Mon, 7 Jul 2025 16:51:03 +0200 (CEST) X-Virus-Scanned: by Amavis at mailfr00.databene.net Received: from mailfr00.databene.net ([127.0.0.1]) by localhost (databene-mailfr00.evolix.net [127.0.0.1]) (amavis, port 10024) with LMTP id 3AZyW9Bquwkd; Mon, 7 Jul 2025 16:51:01 +0200 (CEST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=data-bene.io; s=2024; t=1751899861; bh=EWq6p5vZ/nsc540lqoylaMLMaNwrSiEBszQT9sw1klI=; h=Date:Subject:To:References:From:In-Reply-To:From; b=dEbCyNhhVOiO+SwCihLg3/s80OwDNaeLIo0DGBK1XF/c9iYx836W+itLlfgaxq2NX 9aTLL3ynkpV1YXoUcZXDcUEh2xKisFRCSrB2ejrM/jMRWmQ9O9tHvIafYrLBh+JFXY SgiId5xCEhCQQ9VYgsRgmud4RCCwzRdhmSq2pjoyKUY2Lcyyb+6r3N8Wvz3HNNrIeO iksjSsUVkvVnRI6AGRhTgMONvJjXVRHq6aDRTMNhgTTg70IZbUeaZ1cwLz6N61S9Vi 7MzWz1zyS7mQDQ6+QdxYK/N4an0BU1sMMYhaYNUC5oT/qymeIXw3oOyRzSS5Mlrbh3 yKTh4Xa7+jWrrCpgynrnsWIcrUpNRreFAZVzKbtlmrYKvXmHplEZqpUvgCFeZgwt/0 wBstXpG7wXle3PFTI1xuv2v8DJbqJzATBM14Be0uPo4Rk3VDdBe8YlAoThF/xKVZTy 07YHYiDfU7il4TkxEjh3w/2kZVS2SvB8gGszezPY6SCsfIyeCFx0Rt4xQbbKIuYXXS 1XEZiQtuZYXZMa9+3aKdgve3/jiVxb8Fv8mtB+geUwMAPXToycsC1NGNYHamKlszfA DmcOCqTNvRWUA6lIPz+xSQC6tQPOxkOr2zvFsqdQDYhkjRrzlxk1kevt/vs/MTEEgo nL+4h9OIU6TUHkj6WkGWw4CA= Received: from [127.0.0.1] (257400053.box.freepro.com [95.178.90.96]) by mailfr00.databene.net (Postfix) with ESMTPSA id 791FC5F2A1; Mon, 7 Jul 2025 16:51:01 +0200 (CEST) Message-ID: Date: Mon, 7 Jul 2025 14:51:00 +0000 MIME-Version: 1.0 Subject: Re: Adding basic NUMA awareness - Preliminary feedback and outline for an extensible approach To: Tomas Vondra , PostgreSQL Hackers References: <099b9433-2855-4f1b-b421-d078a5d82017@vondra.me> <1caea3b1-3e0b-4bdb-a630-75671f1f837a@data-bene.io> <8b3341ee-1f8e-4dbb-8046-410f71d4a0cb@vondra.me> From: =?UTF-8?Q?C=C3=A9dric_Villemain?= Autocrypt: addr=cedric.villemain@data-bene.io; keydata= xsBNBEvW1WwBCAC6CG3zZnRpQwmSiFoTjaHlgt7RQ2RmYDqSB7DNtOItV9bBDUe4DKxV9iNF SoD2yV2LrzsYghWXwI0snHGVGCLkJFYBkqyMnJeli5PoHcn9jI12mOz0hdpsTmTJbH+JCLXF admIjh+sz+m7X4net3UQhj8tCaExkdNsw7FWfNr6oHOVkLWlTWh1df1dfTZ3CBZ8vc1L6dIn mWe3i2sRGQ/fCy7XfLqjFe5U+D3jXmqF92p7n8v0vwDZarn4MVeBegTtBYUxpM8Bj78Lga9a SW+ojYo21Zk/TYn+fdOX4L9nNiRFgnAYVjPlWwjV30WpVlQ56o8U+zV2hCNRQyl5QxkNABEB AAHNMUPDqWRyaWMgVmlsbGVtYWluIDxjZWRyaWMudmlsbGVtYWluQGRhdGEtYmVuZS5pbz7C wI4EEwEKADgWIQQ66LJpfJwdoY4rdHTbIB9Ms1QXmwUCY3ARzwIbAwULCQgHAgYVCgkICwIE FgIDAQIeAQIXgAAKCRDbIB9Ms1QXm9oTB/41lFaXCcwtzLjjN7Qr7lImBjiTOntvhzFOBUMP xZWmrXzVl1jVzQm8ubsZNJFB98kw5MrhZjY0sY4x6Txlh6y/OTtpT0RWfZQOGSmfpMq8QDuV gymCfXyr0t4XHFou31nlaqEz1CyUi8ZaYdutJAV0L8j1e0LUHvTcCmlHOsb1uS+Xf5yc7ub+ eRiGtjXwM+OJBYYkFZ2Ebyw7mHWRF4+B3QXUjZhPCQZWBQE1GeX1KxrSCfSKfqujVWCwgiF9 q5TQisgzVRwPBwsi5Fam2X7UHD8I6ZjaAiKHJXezP/Ied/bup457DlXfOg5ORePJgIldMo0p AtHIY1061TckCPs9zsBNBEvW1WwBCAC1iEAHk3lEWEDp9O/DebejwyNr9Zmun6NXPN5axuSj 5VKWP/2CCmsPkcIQlH70rEtZl4vQjXrdRviRcc56TC/SSXti8uOVr/55uStitTCjKRkpxPdf ReOFuOB7OUkHrE3gF6N0UNgOMgmBsT5+rgFm+xqY6TOrvnDVGUbAGkJIdzgTjzeu96BcBEuF 59r+grsmff8PUGtertKeXBr8NlliYZEFCilqus3PheOetWewysHROQJrqnSkpRP7zJWyFYY5 W6PWKQlUgcItrWsgPlHl5gmoH68zesTlW1rX1Z56V8vLPF7RTAPG6g1J7l29wLxUYTwF5Y64 gy+jXAEUJHKZABEBAAHCwF8EGAECAAkFAkvW1WwCGwwACgkQ2yAfTLNUF5ubKAgAtZdh0QJU Wc7WfZhoGOcAEADZJ9n6GSuhL+oxuhPfym1zsU70241rKYZH1m53CWWo+aNyThCXJx+HSSRV /hLNVW34DErJeNJIYwdxPo5/AjOhIUr4e8gMYuviFESBaMpgl8mSM1B1cHVBMZcsQb43Rc3V VfIMNRc4NB16uc7Sm++fbraQq13rB8HC6uYu7PbEAdX3C0IokR3JGb1NghQKga/OoU22KPEx Y+bFk4h3vq9MjlKLir0UJZHKSQ5xec6RcehoMBy0FHBEuK/72xN36dR/3bVwyeR76S7xf9UQ gXdpciBG95/tLRcpelwx8GaRcivTGc0FCBUzqG/YcCqvcA== In-Reply-To: <8b3341ee-1f8e-4dbb-8046-410f71d4a0cb@vondra.me> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk >> * Others might use it to integrate PostgreSQL's own resources (e.g., >> "areas" of shared buffers) into policies. >> >> Hope this perspective is helpful. >=20 > Can you explain how you want to manage this by an extension defined at > the SQL level, when most of this stuff has to be done when setting up > shared memory, which is waaaay before we have any access to catalogs? I should have said module instead, I didn't follow carefully but at some=20 point there were discussion about shared buffers resized "on-line". Anyway, it was just to give some few examples, maybe this one is to be=20 considered later (I'm focused on cgroup/psi, and precisely reassigning=20 PIDs as needed). --=20 C=C3=A9dric Villemain +33 6 20 30 22 52 https://www.Data-Bene.io PostgreSQL Support, Expertise, Training, R&D