The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Different memory utilization
We did 2 similar test installations of Vertica database on virtual RedHat system (the same OS version, RAM and CPU core used, standalone version). Both intances had the same data loaded but we observed strange difference in memory utilization. First instance used average 16-20% of memory (reported by memory_usage table) during normal workload and second one reported always 70%-80% of memory usage (even after database stop and start it goes immediately up to 70% with no workload). The only difference I found was different VMWare version and different hardware configuration, but OS and Vertica files and configuration (especially Vertica parameters) were exactly the same. Is it possible that different hardware or VMWare version can have such impact on memory consumption by HP Vertica? We used version HP Vertica 6.1.2 and RHEL 6.4 64bit.