Project

General

Profile

Enhancement #462

Try HugePages for PG

Added by Marc Dequènes over 5 years ago. Updated over 1 year ago.

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:

Description

See http://www.postgresql.org/docs/9.4/static/kernel-resources.html#LINUX-HUGE-PAGES

History

#1

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.

#2

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.

Also available in: Atom PDF