Re: Estimating HugePages Requirements?

Nathan Bossart <bossartn@amazon.com>

View thread View on postgr.es

From: "Bossart, Nathan" <bossartn@amazon.com>

To: Mark Dilger <mark.dilger@enterprisedb.com>

Cc: Don Seiler <don@seiler.us>, "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>

Date: 2021-08-09T22:57:18Z

Lists: pgsql-hackers

Attachments

v2-0001-add-pg_ctl-option-for-retreiving-shmem-size.patch (application/octet-stream) patch v2-0001

On 6/9/21, 8:09 PM, "Bossart, Nathan" <bossartn@amazon.com> wrote:
> On 6/9/21, 3:51 PM, "Mark Dilger" <mark.dilger@enterprisedb.com> wrote:
>>> On Jun 9, 2021, at 1:52 PM, Bossart, Nathan <bossartn@amazon.com> wrote:
>>>
>>> I'd be happy to clean it up and submit it for
>>> discussion in pgsql-hackers@ if there is interest.
>>
>> Yes, I'd like to see it.  Thanks for offering.
>
> Here's the general idea.  It still needs a bit of polishing, but I'm
> hoping this is enough to spark some discussion on the approach.

Here's a rebased version of the patch.

Nathan

Commits

Silence extra logging when using "postgres -C" on runtime-computed GUCs
- 8bbf8461a3a2 15.0 landed
doc: Improve postgres command for shared_memory_size_in_huge_pages
- bbd4951b73ec 15.0 landed
Introduce GUC shared_memory_size_in_huge_pages
- 43c1c4f65eab 15.0 landed
Support "postgres -C" with runtime-computed GUCs
- 0c39c292077e 15.0 landed
Make shared_memory_size a preset option
- 3b231596ccfc 15.0 landed
Introduce GUC shared_memory_size
- bd1788051b02 15.0 landed
Move the shared memory size calculation to its own function
- 0bd305ee1d42 15.0 landed
Add new GUC, max_worker_processes, limiting number of bgworkers.
- 6bc8ef0b7f1f 9.4.0 cited