Re: [GENERAL] Huge Pages - setting the right value - Mailing list pgsql-general

From Andrew Kerber
Subject Re: [GENERAL] Huge Pages - setting the right value
Date
Msg-id CAJvnOJbwBNFRSzaViasUUWsTomD9KCQParbB8_2gTOz7QxU5Yw@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] Huge Pages - setting the right value  (Lucas Possamai <drum.lucas@gmail.com>)
Responses Re: [GENERAL] Huge Pages - setting the right value
List pgsql-general
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@gmail.com> wrote:
2017-06-12 7:52 GMT+12:00 Andrew Kerber <andrew.kerber@gmail.com>:
I am sure it does not.

Sent from my iPhone

> On Jun 11, 2017, at 10:50 AM, pinker <pinker@onet.eu> 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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
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.'

pgsql-general by date:

Previous
From: Lucas Possamai
Date:
Subject: Re: [GENERAL] Huge Pages - setting the right value
Next
From: Lucas Possamai
Date:
Subject: Re: [GENERAL] Huge Pages - setting the right value