Limit Memory Usage of Vertica

anshulupadhyay

Hi,
I've a vertica setup [16 core 32GB RAM] where some other products are also installed. I've observed that vertica consumes the RAM over the period of 5-7 days after which other products starts crashing due to memory issue. We also have a setup where Vertica is installed in 2 different nodes, there also, the available free memory goes down to less than a GB over the period of time.
Can you please suggest a way such that we can limit the memory usage of Vertica, such that other products in the system are not impacted.

Thanks
Anshul

Jim_Knicely

Hi,

Check out the important notice on the "General Hardware and OS Requirements and Recommendations" doc page:

Important: Deploy Vertica as the only active process on each host—other than Linux processes or software explicitly approved by Vertica. Vertica cannot be colocated with other software. Remove or disable all non-essential applications from cluster hosts.

See:
https://www.vertica.com/docs/9.1.x/HTML/index.htm#Authoring/InstallationGuide/BeforeYouInstall/platformhardwarereqts.htm

That being said, take a look at the MAXMEMORYSIZE parameter of the GENERAL pool.

See:
https://www.vertica.com/docs/9.1.x/HTML/index.htm#Authoring/SQLReferenceManual/Statements/Built-inPools.htm#GENERAL
https://www.vertica.com/docs/9.1.x/HTML/index.htm#Authoring/AdministratorsGuide/ResourceManager/Scenarios/RestrictingVerticaToTakeOnly60OfMemory.htm

anshulupadhyay

Thanks for your input, I was able to alter the resource pool to reduce the maxmemorysize.