Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <pgsql-performance-owner+archive@lists.postgresql.org>)
	id 1jTgbq-0006Wu-A8
	for pgsql-performance@arkaria.postgresql.org; Wed, 29 Apr 2020 06:54:18 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-performance-owner+archive@lists.postgresql.org>)
	id 1jTgbp-0007Ai-4r
	for pgsql-performance@arkaria.postgresql.org; Wed, 29 Apr 2020 06:54:17 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <marc4@rechte.fr>)
	id 1jTgbo-0007Ab-Tf
	for pgsql-performance@lists.postgresql.org; Wed, 29 Apr 2020 06:54:16 +0000
Received: from 10.mo5.mail-out.ovh.net ([46.105.52.148])
	by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <marc4@rechte.fr>)
	id 1jTgbl-0002B8-Nx
	for pgsql-performance@lists.postgresql.org; Wed, 29 Apr 2020 06:54:15 +0000
Received: from player739.ha.ovh.net (unknown [10.110.208.160])
	by mo5.mail-out.ovh.net (Postfix) with ESMTP id 66A7227A928
	for <pgsql-performance@lists.postgresql.org>;
 Wed, 29 Apr 2020 08:54:10 +0200 (CEST)
Received: from rechte.fr (92.251.23.93.rev.sfr.net [93.23.251.92])
	(Authenticated sender: marc4@rechte.fr)
	by player739.ha.ovh.net (Postfix) with ESMTPSA id B546BDD4E672
	for <pgsql-performance@lists.postgresql.org>;
 Wed, 29 Apr 2020 06:54:09 +0000 (UTC)
To: pgsql-performance@lists.postgresql.org
From: =?UTF-8?Q?Marc_Recht=c3=a9?= <marc4@rechte.fr>
Subject: NUMA settings
Message-ID: <2d10f8ab-5fc6-a0a5-facf-68f35de95ea9@rechte.fr>
Date: Wed, 29 Apr 2020 08:54:08 +0200
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101
 Thunderbird/68.7.0
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-15; format=flowed
Content-Language: en-US
Content-Transfer-Encoding: 7bit
X-Ovh-Tracer-Id: 2634887259850463309
X-VR-SPAMSTATE: OK
X-VR-SPAMSCORE: 0
X-VR-SPAMCAUSE: 
 gggruggvucftvghtrhhoucdtuddrgeduhedriedvgdduuddtucetufdoteggodetrfdotffvucfrrhhofhhilhgvmecuqfggjfdpvefjgfevmfevgfenuceurghilhhouhhtmecuhedttdenucenucfjughrpefvhffukffffgggtgfgsehtjeertddtfeelnecuhfhrohhmpeforghrtggptfgvtghhthoruceomhgrrhgtgeesrhgvtghhthgvrdhfrheqnecukfhppedtrddtrddtrddtpdelfedrvdefrddvhedurdelvdenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhhouggvpehsmhhtphdqohhuthdphhgvlhhopehplhgrhigvrhejfeelrdhhrgdrohhvhhdrnhgvthdpihhnvghtpedtrddtrddtrddtpdhmrghilhhfrhhomhepmhgrrhgtgeesrhgvtghhthgvrdhfrhdprhgtphhtthhopehpghhsqhhlqdhpvghrfhhorhhmrghntggvsehlihhsthhsrdhpohhsthhgrhgvshhqlhdrohhrgh
List-Id: <pgsql-performance.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-performance@lists.postgresql.org>
List-Owner: <mailto:pgsql-performance-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-performance>
Precedence: bulk

Hello,

I am trying to figure out the recommended settings for a PG dedicated 
machine regarding NUMA.

I assume that the shared buffers are using Huge Phages only. Please 
correct if I am wrong:

1) postgres is started with numactl --interleave=all, in order to spread 
memory pages evenly on nodes.
2) wm.swappiness is left to the default 60 value, because Huge Pages 
never swap, and we wish the idle backend to be swapped out if necessary.
3) vm.zone_reclaim_mode = 0. I am not sure it is the right choice.
4) kernel.numa_balancing = 1. Only if it is confirmed that it will not 
affect postgres, because started with the interleave policy.

Thanks