Enhancement #462
Try HugePages for PG
Status:
New
Priority:
Low
Assignee:
-
Category:
Service :: Database
Start date:
2015-07-12
Due date:
% Done:
0%
Estimated time:
Patch Available:
Confirmed:
No
Branch:
Entity:
DuckCorp
Security:
Help Needed:
History
Updated by Marc Dequènes almost 4 years ago
With transparent huge pages maybe it would be automatic. Seems 9.4 is able to handle it but it must be globally enabled using sysctl.
Updated by Marc Dequènes over 1 year ago
It seems to be clear we should disable transparent huge pages for all workloads:
https://www.percona.com/blog/2019/03/06/settling-the-myth-of-transparent-hugepages-for-databases/
Also recommended by PG doc.
Setting huge pages manually and adapting over time might be a pain though.