pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Marc Rechté <marc4@rechte.fr>
To: pgsql-performance@lists.postgresql.org
Subject: Re: NUMA settings
Date: Tue, 05 May 2020 10:25:57 +0200
Message-ID: <78e4af96a4b34f1280ef96ddf347d5f7b8a53380.camel@cybertec.at> (raw)
In-Reply-To: <9149ca0b-3e36-9df2-1ea5-2ad3af7968de@rechte.fr>
References: <2d10f8ab-5fc6-a0a5-facf-68f35de95ea9@rechte.fr>
	<e4d2e9c66efebc14e7f13ed2c26171f7cd9f85ac.camel@cybertec.at>
	<20200504162042.3ctwpkg33trpyfdm@alap3.anarazel.de>
	<fd8fb5bd-eac6-7491-f1e8-3761387d9d03@rechte.fr>
	<60b780e9d34ea8a6be80193ec03ab16a160fd1eb.camel@cybertec.at>
	<9149ca0b-3e36-9df2-1ea5-2ad3af7968de@rechte.fr>

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 swapped out if 
> necessary. Therefore lowering swappiness would produce the opposite 
> effect: swapping out Linux file cache rather than backends memory.

I see.  Sorry for not paying attention.

An idle backend consumes only a few MB of RAM, though.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com






view thread (7+ messages)

Message-ID: <78e4af96a4b34f1280ef96ddf347d5f7b8a53380.camel@cybertec.at>
Permalink:  ../78e4af96a4b34f1280ef96ddf347d5f7b8a53380.camel@cybertec.at/
Also on:    postgresql.org/message-id/78e4af96a4b34f1280ef96ddf347d5f7b8a53380.camel@cybertec.at

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: laurenz.albe@cybertec.at, marc4@rechte.fr, pgsql-performance@lists.postgresql.org
  Subject: Re: NUMA settings
  In-Reply-To: <78e4af96a4b34f1280ef96ddf347d5f7b8a53380.camel@cybertec.at>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox