Re: Estimating HugePages Requirements?

From: "Bossart, Nathan" <bossartn(at)amazon(dot)com>
To: Magnus Hagander <magnus(at)hagander(dot)net>, Michael Paquier <michael(at)paquier(dot)xyz>
Cc: Andres Freund <andres(at)anarazel(dot)de>, Mark Dilger <mark(dot)dilger(at)enterprisedb(dot)com>, Don Seiler <don(at)seiler(dot)us>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Estimating HugePages Requirements?
Date: 2021-08-27 18:16:01
Message-ID: 907F88C0-54F6-4E4A-A4D0-2DB2353AA749@amazon.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-hackers

On 8/27/21, 7:41 AM, "Magnus Hagander" <magnus(at)hagander(dot)net> wrote:
> On Fri, Aug 27, 2021 at 8:46 AM Michael Paquier <michael(at)paquier(dot)xyz> wrote:
>> On Wed, Aug 11, 2021 at 11:23:52PM +0000, Bossart, Nathan wrote:
>> > While testing this new option, I noticed that you can achieve similar
>> > results today with the following command, although this one will
>> > actually try to create the shared memory, too.
>>
>> That may not be the best option.
>
> I would say that can be a disastrous option.
>
> First of all it would probably not work if you already have something
> running -- especially when using huge pages. And if it does work, in
> that or other scenarios, it can potentially have significant impact on
> a running cluster to suddenly allocate many GB of more memory...

The v3 patch actually didn't work if the server was already running.
I removed that restriction in v4.

>> > IMO the new option is still handy, but I can see the argument that it
>> > might not be necessary.
>>
>> A separate option looks handy. Wouldn't it be better to document it
>> in postgres-ref.sgml then?
>
> I'd say a lot more than just handy. I don't think the workaround is
> really all that useful.

I added some documentation in v4.

Nathan

Attachment Content-Type Size
v4-0001-introduce-option-for-retreiving-shmem-size.patch application/octet-stream 13.5 KB

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Andres Freund 2021-08-27 18:46:48 Re: Estimating HugePages Requirements?
Previous Message Laurenz Albe 2021-08-27 15:09:58 Re: slave stops replica

Browse pgsql-hackers by date

  From Date Subject
Next Message David Christensen 2021-08-27 18:22:24 Re: [PATCH] Proof of concept for GUC improvements
Previous Message Peter Geoghegan 2021-08-27 17:52:13 Re: log_autovacuum in Postgres 14 -- ordering issue