pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Troels Arvin <troels@arvin.dk>
To: pgsql-general@lists.postgresql.org
Subject: Calculating vm.nr_hugepages
Date: Wed, 30 Aug 2023 15:12:13 +0200
Message-ID: <43ddf925-9c8b-b023-282c-b20e9366077d@arvin.dk> (raw)

Hello,

I'm writing an Ansible play which is to set the correct value for 
vm.nr_hugepages on Linux servers where I hope to make Postgres make use 
of huge pages.

However, I'm struggling to find the right formula.

I assume I need to find the same value as I get from running "postgres 
-C shared_memory_size_in_huge_pages". I call that my target value.
Note: I cannot simply run "postgres -C ...", because I need my Ansible 
play to work against a server where Postgres is running.

I've tried using the formula described at 
https://www.cybertec-postgresql.com/en/huge-pages-postgresql/, but it 
produces a different value than my target:

Using a shared_buffers value of 21965570048, like in Cybertec 
Postgresql's example:
"postgres ... -C 21965570048B" yields: 10719
The formula from Cybertec Postgresql says: 10475

I've also tried doing what ChatGPG suggested:
Number of Huge Pages when shared_buffers is set to 1 GiB = 
shared_buffers / huge_page_size
                     = 1073741824 bytes / 2097152 bytes
                     = 512
But that's also wrong compared to "postgres -C ..." (which said 542).

Which formula can I use? It's OK for me for it to be slightly wrong 
compared to "postgres -C", but if it's wrong, it needs to be slightly 
higher than what "postgres -C" outputs, so that I'm sure there's enough 
huge pages for Postgres to be able to use them properly.

-- 
Kind regards,
Troels Arvin







view thread (3+ messages)  latest in thread

Message-ID: <43ddf925-9c8b-b023-282c-b20e9366077d@arvin.dk>
Permalink:  ../43ddf925-9c8b-b023-282c-b20e9366077d@arvin.dk/
Also on:    postgresql.org/message-id/43ddf925-9c8b-b023-282c-b20e9366077d@arvin.dk

 · 

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-general@postgresql.org
  Cc: troels@arvin.dk
  Subject: Re: Calculating vm.nr_hugepages
  In-Reply-To: <43ddf925-9c8b-b023-282c-b20e9366077d@arvin.dk>
  References: <43ddf925-9c8b-b023-282c-b20e9366077d@arvin.dk>

* 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