Vertica memory recommendation

book

Article ID: 221239

calendar_today

Updated On:

Products

CA Performance Management - Usage and Administration

Issue/Introduction

We are about to install more memory in our DR instance, we will have about 350GB of physical memory, we would like a recommendation from BC/Vertica on how much memory "should" we expose to the OS for Vertica? Possibly there is some downside to "too much" memory? 

Cause

There is no limit on memory per Vertica host

Environment

Release : 21.2

Component : IM Data Storage

Resolution

Vertica automatically uses upto 95% of the max memory on the box, after reboot.

general resource pool is set to 95% maxmemorysize OOTB.  Nothing to do when adding more memory to DR boxes.

Additional Information

How to add more memory and/or CPU to vertica hosts

https://knowledge.broadcom.com/external/article/213360/