On Tue, 2020-05-05 at 07:56 +0200, Marc Rechté wrote:
> Thanks for answers. Further readings make me think that we should *not*
> start postgres with numactl --interleave=all: this may have counter
> productive effect on backends anon memory (heap, stack). IMHO, what is
> important is to use Huge Pages for shared buffers: they are allocated
> (reserved) by the kernel at boot time and spread evenly on all nodes. On
> top of that they never swap.
>
> My (temp) conclusions are following:
> vm.zone_reclaim_mode = 0
> kernel.numa_balancing = 0 (still not sure with that choice)
> wm.swappiness = 60 (default)
> start postgres as usual (no numactl)
Thanks for sharing your insights.
I think that "vm.swappiness" should be 0.
PostgreSQL does its own memory management, any swapping by the kernel
would go against that.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com