On Tue, 2020-05-05 at 10:11 +0200, Marc Rechté wrote:
> > 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
> >
> As said in the post, we wish the idle backends to be swapp
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 f
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 Hug
Hi,
On 2020-04-29 10:50:54 +0200, Laurenz Albe wrote:
On Wed, 2020-04-29 at 08:54 +0200, Marc Rechté wrote:
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:
Hi,
On 2020-04-29 10:50:54 +0200, Laurenz Albe wrote:
> On Wed, 2020-04-29 at 08:54 +0200, Marc Rechté wrote:
> > 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
> > cor
On Wed, 2020-04-29 at 08:54 +0200, Marc Rechté wrote:
> 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 --inte
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 no
