Re: Huge Pages - setting the right value

[Andrew Kerber <andrew.kerber@xxxxxxxxx>]

Was that transparent hugepages or standard hugepages?  databases commonly have problems dealing with transparent hugepages.

On Sun, Jun 11, 2017 at 4:39 PM, Lucas Possamai <drum.lucas@xxxxxxxxx> wrote:

2017-06-12 7:52 GMT+12:00 Andrew Kerber <andrew.kerber@xxxxxxxxx>:

I am sure it does not.

Sent from my iPhone

> On Jun 11, 2017, at 10:50 AM, pinker <pinker@xxxxxxx> wrote:
>
> Andrew Kerber wrote
>> I can't give you an absolutely authoritative answer, but because of the
>> way hugepages are implemented and allocated, I can't think how they could
>> be used for other processes.  Linux hugepages are either 2m or 1g, far too
>> large for any likely processes to require. They cannot be allocated in
>> partial pages.
>
> thank you for your help.
> My system is using 2MB pages for shared buffers. I have checked and one of
> my processes has used 606788kB of memory, so potentially could use ~ 300
> huge pages, but does postgres can use it for non shared memory?
>
>
>
>
> --
> View this message in context: http://www.postgresql-archive.org/Huge-Pages-setting-the-right-value-tp5952972p5965963.html
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

In my case, we had the HugePages enabled but not configured in our Master DB Server. When we increased the server resources (More RAM & CPU) we had lots of issues with HugePages. Specially I/O ones. Had to disabled it.

Running Ubuntu 14.04 Server @ Amazon.

Lucas

--

Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'