Limit Memory Usage of Vertica
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.