Project

General

Profile

Actions
Copy link

Enhancement #462

open

Try HugePages for PG

Added by Marc Dequènes about 10 years ago. Updated almost 6 years 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

Actions
Copy link
 #1

Updated by Marc Dequènes over 8 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.

Actions
Copy link
 #2

Updated by Marc Dequènes almost 6 years 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.

Actions
Copy link

Also available in: Atom PDF