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 1uUffa-006nyF-7R for pgsql-hackers@arkaria.postgresql.org; Thu, 26 Jun 2025 06:01: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 1uUffY-008Hgd-A3 for pgsql-hackers@arkaria.postgresql.org; Thu, 26 Jun 2025 06:01:08 +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 1uUffY-008HgO-0J for pgsql-hackers@lists.postgresql.org; Thu, 26 Jun 2025 06:01:08 +0000 Received: from mail-wm1-x335.google.com ([2a00:1450:4864:20::335]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uUffT-0043JN-1l for pgsql-hackers@lists.postgresql.org; Thu, 26 Jun 2025 06:01:07 +0000 Received: by mail-wm1-x335.google.com with SMTP id 5b1f17b1804b1-4538bc52a8dso645835e9.2 for ; Wed, 25 Jun 2025 23:01:03 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1750917662; x=1751522462; darn=lists.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=YSVC4iUZrvVlMAu/DXPwD+DXi7y+0R2Rv14XPHmCx6I=; b=X1sK8jp4H3ryNKrIe4xemP+nHg+7H34kdKgrGLAnI3PBTw5wmOtY8yyQWg+OKe+JRB N26C3RdxDSDD/e7Ra2NVO+8ZIyYgTjV2LItIWaCPwfO8YQO2NOtuZKOHc6DoF1bWZoT1 kU3zAeeLj8GL6AnoxGFlPSjA9APbdmCPytJFmbO0CPDGfUGwTWLdJUodxpHETVqWXxqw PbmdFhBcTnsmWjCYaUsfxvc8tu00NYY+D5alYwdEUyFpl/EPWWz/hq90h078RByTa3RR PK1hAhveDXiF0VWcBmV0jYsikjd1znHBTBqEZxxv+t4A60I8dKIfjjvsY6nyTgru2oHX k3XQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1750917662; x=1751522462; 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=YSVC4iUZrvVlMAu/DXPwD+DXi7y+0R2Rv14XPHmCx6I=; b=OcfotW85J8jyC3RyypJZ2S/scxiTkfc1GK8ZIpc4y5wXHHaysYc1IvD6JMd8ubS1DK xobBhGWfVZ8CVTVogjpD9dwPIYGmLscSt3KxJ989/WlpjcdxPLI4/YrY0FaDvMRvNIrS TEOf56DIo5AW79tXg6b1bpnV2DVyDbK8vc3iLInFb+5OdLBPfyi5VHpMD4++DEA5V3Jb fFoL62dDoPR55pLWFexNLQpSt3102qenDd0BRS+X6qLtGJvhGsMb6QTSGOWr/nYAF05Q X/Gx+kCDn6c8mdp8o/t7P2AfJZ66tv7TfjCyzszNuYkiFmUuYULVVPEwrio+gGd6TAlf 6TFw== X-Forwarded-Encrypted: i=1; AJvYcCW99ATegAcI+DCRF9hm8n+tGiQYSxFMdwOWzo68Sx72NzSDvprWYFeOlqK+PNRcWuOr5zqGKFcudH45nT2Q@lists.postgresql.org X-Gm-Message-State: AOJu0YzF/ij2o1gCMWXM8nhh2kukoMa122cuJs24lyzaTacEnE6l1Bi3 itE4YOCyGElgBebtmwlwq+hl6IJalAyi4eNrlgOT8XSPTqKJGf6USnOIZQt4Yg== X-Gm-Gg: ASbGncuTH2c4U35vriH0XvTDQ62Po7qMN1/rcukOOOVva5gOSIsHOxU5LajdZOpe2e2 ofYFZztpijJjV4VyX6qB9DTMMS/q9+kxc8DLbOIa5ClcLV++tTnWMv3g/C8Vs9XIumF32fLeSW8 5wfJmP72+xpsbSY+Dm3twWXTfJZ/j0gedT8HlTn1Y2lUkhxzTw6s3DqubKaHOthn0o5QLnfsZtv 4NuoIvb5TrOJ5GwjT9QsR6sT2psvSvUOm6r5mFNF7aLK0tnxnb03VdAo0sytk0B2AtibwmijgAO TdVNR5kGLXKEfKS4dk2hEoVeT/OMrSCbDVHWUaZPwkXY632tJ9BrXzPqU5NGWz4Ag1qDM4Wy7V9 vm9YxwLypqn5Fihmd9fGsklaTIRPDisUcNK+OJ4PIWwXxo9riCOg8IGUBucQZ4mw+OjSLx5UAxH w1ucC1Gvrcjk26x19xYA== X-Google-Smtp-Source: AGHT+IHnKiGwk6fJEoAlLFw27bcrG/0FYD7Vg0rPeypcCZ4AxDpLqT+sbB8WA83aL6tDen8sYlZO9w== X-Received: by 2002:a05:600c:1e8b:b0:445:49e:796b with SMTP id 5b1f17b1804b1-45381af6aa7mr64811455e9.17.1750917661589; Wed, 25 Jun 2025 23:01:01 -0700 (PDT) Received: from ip-10-97-1-34.eu-west-3.compute.internal (ec2-15-237-181-182.eu-west-3.compute.amazonaws.com. [15.237.181.182]) by smtp.gmail.com with ESMTPSA id 5b1f17b1804b1-4538a3b2fd7sm8908755e9.17.2025.06.25.23.01.01 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 25 Jun 2025 23:01:01 -0700 (PDT) Date: Thu, 26 Jun 2025 06:00:59 +0000 From: Bertrand Drouvot To: Tomas Vondra Cc: Christoph Berg , Andres Freund , Tomas Vondra , pgsql-hackers@lists.postgresql.org Subject: Re: pgsql: Introduce pg_shmem_allocations_numa view Message-ID: References: <6342f601-77de-4ee0-8c2a-3deb50ceac5b@vondra.me> <8649a4e3-c60d-4f37-aa6f-e7e7c14c581e@vondra.me> <8961c087-e49b-4b16-9437-31331625215c@vondra.me> 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 Hi, On Tue, Jun 24, 2025 at 10:32:25PM +0200, Tomas Vondra wrote: > On 6/24/25 17:30, Christoph Berg wrote: > > Re: Tomas Vondra > >> If it's a reliable fix, then I guess we can do it like this. But won't > >> that be a performance penalty on everyone? Or does the system split the > >> array into 16-element chunks anyway, so this makes no difference? > > > > There's still the overhead of the syscall itself. But no idea how > > costly it is to have this 16-step loop in user or kernel space. > > > > We could claim that on 32-bit systems, shared_buffers would be smaller > > anyway, so there the overhead isn't that big. And the step size should > > be larger (if at all) on 64-bit. > > > >> Anyway, maybe we should start by reporting this to the kernel people. Do > >> you want me to do that, or shall one of you take care of that? I suppose > >> that'd be better, as you already wrote a fix / know the code better. > > > > Submitted: https://marc.info/?l=linux-mm&m=175077821909222&w=2 > > > > Thanks! Now we wait ... It looks like that the bug is "confirmed" and that it will be fixed: https://marc.info/?l=linux-kernel&m=175088392116841&w=2 Regards, -- Bertrand Drouvot PostgreSQL Contributors Team RDS Open Source Databases Amazon Web Services: https://aws.amazon.com