Should we enable NUMA in the BIOS?

Moderator: NorbertKrupa

Post Reply
MisterVertica
Newbie
Newbie
Posts: 2
Joined: Tue Jan 26, 2016 2:39 pm

Should we enable NUMA in the BIOS?

Post by MisterVertica » Tue Jan 26, 2016 2:42 pm

What is the recommendation on enabling NUMA in the BIOS? Does anyone have any experience with systems where this is enabled or disabled, especially where servers have 512GB+ of RAM?

NorbertKrupa
GURU
GURU
Posts: 527
Joined: Tue Oct 22, 2013 9:36 pm
Location: Chicago, IL
Contact:

Re: Should we enable NUMA in the BIOS?

Post by NorbertKrupa » Tue Jan 26, 2016 2:49 pm

typical recommendation is to switch off NUMA in the BIOS.
What's the relationship between Vertica and NUMA?
Checkout vertica.tips for more Vertica resources.

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1825
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: Should we enable NUMA in the BIOS?

Post by JimKnicely » Wed Jan 27, 2016 2:23 pm

Hi,

The following link has documentation for the HP ProLiant Gen9 server. It states the following about Node Interleaving:
Use this option to enable or disable NUMA node interleaving. Typically, you can obtain optimum performance on NUMA nodes by leaving this option disabled (the default setting). When this option is enabled, memory addresses are interleaved across the memory installed for each processor and some workloads might experience improved performance.

IMPORTANT: Enabling Node Interleaving can impact operating system performance.
And here is a link to a "Vertica Developer Community" post that may help:
P.S. For those reading this who do not know what NUMA is, check out this link:
Jim Knicely

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “New to Vertica Database Administration”