public inbox for [email protected]
help / color / mirror / Atom feedFrom: Don Seiler <[email protected]>
To: P C <[email protected]>
Cc: Magnus Hagander <[email protected]>
Cc: Julien Rouhaud <[email protected]>
Cc: Tom Lane <[email protected]>
Cc: pgsql-admin <[email protected]>
Subject: Re: Estimating HugePages Requirements?
Date: Wed, 9 Jun 2021 22:55:08 -0500
Message-ID: <CAHJZqBATodSGXZ2vD_4efKdmAdaN0ucP=m93KL7Xmf5jqNzvYw@mail.gmail.com> (raw)
In-Reply-To: <CADrzpjFQ8awR62Y0GC7K=ohtnBeAL06jkuMHqh6neCF3H89jMw@mail.gmail.com>
References: <CAHJZqBBLHFNs6it-fcJ6LEUXeC5t73soR3h50zUSFpg7894qfQ@mail.gmail.com>
<CAOBaU_ZHtRhG+MvoT6=HpbMoK=JnsJHBMmxQ-XLSVoh6fFqJHQ@mail.gmail.com>
<CABUevExXvoPvLN70CznmQfbjwxnrdXo9gXxZwGpBoUhjtFi3Ng@mail.gmail.com>
<[email protected]>
<CABUevEzn7fZmZ-8m4ph0wBa1bqz32ghWh-vjhf+Vh0OjW9EdQw@mail.gmail.com>
<[email protected]>
<CABUevEzwS3zG3X6dpSZTy-u1LoJ8kRS_A493mFdMii3_AhX-Ew@mail.gmail.com>
<CADrzpjFQ8awR62Y0GC7K=ohtnBeAL06jkuMHqh6neCF3H89jMw@mail.gmail.com>
On Wed, Jun 9, 2021, 21:03 P C <[email protected]> wrote:
> I agree, its confusing for many and that confusion arises from the fact
> that you usually talk of shared_buffers in MB or GB whereas hugepages have
> to be configured in units of 2mb. But once they understand they realize its
> pretty simple.
>
> Don, we have experienced the same not just with postgres but also with
> oracle. I havent been able to get to the root of it, but what we usually do
> is, we add another 100-200 pages and that works for us. If the SGA or
> shared_buffers is high eg 96gb, then we add 250-500 pages. Those few
> hundred MBs may be wasted (because the moment you configure hugepages, the
> operating system considers it as used and does not use it any more) but
> nowadays, servers have 64 or 128 gb RAM easily and wasting that 500mb to
> 1gb does not hurt really.
>
I don't have a problem with the math, just wanted to know if it was
possible to better estimate what the actual requirements would be at
deployment time. My fallback will probably be you did and just pad with an
extra 512MB by default.
Don.
view thread (108+ messages) latest in thread
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: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected], [email protected]
Subject: Re: Estimating HugePages Requirements?
In-Reply-To: <CAHJZqBATodSGXZ2vD_4efKdmAdaN0ucP=m93KL7Xmf5jqNzvYw@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox