| From: | Adrien Nayrat <adrien(dot)nayrat(at)dalibo(dot)com> |
|---|---|
| To: | Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>, Justin Pryzby <pryzby(at)telsasoft(dot)com> |
| Cc: | Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Doc tweak for huge_pages? |
| Date: | 2017-12-04 08:48:44 |
| Message-ID: | 4cc3fb22-d187-86f5-3b52-a786894fc74f@dalibo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 12/01/2017 05:35 AM, Thomas Munro wrote:
>> since it also
>> supports "transparent" hugepages.
> Hmm. Yeah, it does, but apparently it's not so transparent.
+1. We saw performance drop with transparent_hugepage enabled on server with
more than 256GB RAM. Access to the cache where slow down when kernel try to
defragment pages.
When that happens, we saw the function isolate_freepages_block appearing in most
consuming function with perf top.
Thanks to Marc Cousin analysis, putting "madvise" to
/sys/kernel/mm/transparent_hugepage/enabled solved the problem. He also notice
that THP only works for "anonymous memory mappings"[1] (shared_buffers are not
anonymous).
1: https://www.kernel.org/doc/Documentation/vm/transhuge.txt
Regards,
--
Adrien NAYRAT
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Huong Dangminh | 2017-12-04 09:26:00 | RE: Re: User defined data types in Logical Replication |
| Previous Message | Alexander Korotkov | 2017-12-04 08:29:44 | Re: [HACKERS] proposal: psql command \graw |