Vertica catalog - memory issue
Hi , I am checking vertica as an database solution to a product we develop that will run on SAAS , when we design SAAS solution one of the basic test we run is to check how database behave to big catalogs (many tables) . Our test show that vertica probably load the entire catalog into memory as we see dramatic memory growth when we run out test 10K tables+ super projection. Btw – the memory growth was not show on the resource pools data dictionary tables , so checking them don’t present any issue . We look behave was present on the level of OS monitor tools that we run on top of vertica process . I would like to know if this us expect behave .