Huge/super pages seem to help a lot with PostgreSQL on FreeBSD (code, main shm area, parallel query shm segments). I suspect that on Linux the problem is the "transparent" part doesn't work well yet, and it doesn't work at all for some classes of memory we care about.
-
-
-
AFAIK it's actually recommended to use regular Huge Pages for Postgres on Linux - its just the transparent part that causes issues.
@AndresFreundTec has done benchmarking on this, I believe. - Još 1 odgovor
Novi razgovor -
-
-
My understanding (and it has been a while) is that they can have big benefits or KVM based VMs. That is the context where I've heard about them in the past.
-
It certainly often helps to optimize the page table walks needed on TLB miss on systems that use hardware based SLAT (e.g., Intel EPT). But it is also very useful generally for database performance, and for some systems that need larger contiguous regions of physical memory.
- Još 1 odgovor
Novi razgovor -
-
-
For servers that are specialized for storage, helps with fs buffer cache.
Hvala. Twitter će to iskoristiti za poboljšanje vaše vremenske crte. PoništiPoništi
-
-
-
I just want medium-sized 64kb pages.
-
Why 64kb? For base page size it's too big: you'll waste a lot RAM in page cache for small files (and files are mostly small). 16kb is sweet spot for base page size. For THP 64kb will not justify overhead on managing them.
- Još 1 odgovor
Novi razgovor -
-
-
IIRC at work we do this with humongous binaries to reduce TLB misses
Hvala. Twitter će to iskoristiti za poboljšanje vaše vremenske crte. PoništiPoništi
-
-
-
It makes Oracle Database work a bit better in some configurations. Even so, Oracle has multiple ways to allocate it's SGA and AFAIR newer implementations use mmaped files in /dev/shm and not directly allocated huge pages any more.
-
In theory, everything allocates huge amounts of ram should be able to see improvements in certain areas, but I think OracleDB was the main "client" of this feature. It seems it also affects in a negative way other workloads, so overall YMMV and must validate your setup live.
Kraj razgovora
Novi razgovor -
Čini se da učitavanje traje već neko vrijeme.
Twitter je možda preopterećen ili ima kratkotrajnih poteškoća u radu. Pokušajte ponovno ili potražite dodatne informacije u odjeljku Status Twittera.