How to make Vertica use all of available CPUs.

  • KM03247167
  • 14-Sep-2018
  • 14-Sep-2018

This document is under revision.

Summary

Vertica does not use all the CPU's of the server

Question

After add more CPU's at the server Vertica does not use all the CPU's 

Answer

After add more CPU's at the server is needed to run the following query to update the parameter 

SELECT SET_CONFIG_PARAMETER('PINPROCESSORSOFFSET', 0);

SELECT SET_CONFIG_PARAMETER('PINPROCESSORS', 2);

PINPROCESSORS: Number of CPUs to which Vertica processes will be pinned

Check the link below:

https://www.vertica.com/docs/8.1.x/HTML/index.htm#Authoring/OEMCookbook/DevelopingAndTesting/ManagingDBResources/ConfiguringCPUResources.htm%3FTocPath%3DBest%2520Practices%2520for%2520OEM%25C2%25A0Customers%7CPart%25201%253A%2520Developing%2520and%2520Testing%2520the%2520Vertica%2520Database%7CManaging%2520Database%2520Resources%7C_____1