On Mon, Dec 04, 2017 at 09:48:44AM +0100, Adrien Nayrat wrote: > 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. > 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).
Note PG since 9.3 can and prefers to use anonymous mmap for shared buffers instead of sysv shm. https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=b0fc0df9364d2d2d17c0162cf3b8b59f6cb09f67 ./src/backend/port/sysv_shmem.c and src/include/portability/mem.h:#define PG_MMAP_FLAGS (MAP_SHARED|MAP_ANONYMOUS|MAP_HASSEMAPHORE) Justin
