What is the maximum amount of memory a Vertica database would use out of the box (no configuration) ?@bat @rbankula
From Optimizing Query Performance and Resource Pool Tuning.
By default Vertica will use 95% of total physical RAM on the machine that the Resource Manager can use for queries.
dbadmin=> SELECT maxmemorysize FROM resource_pools WHERE name = 'general';
Refer to:https://www.vertica.com/docs/9.3.x/HTML/Content/Authoring/SQLReferenceManual/Statements/Built-inPools.htm?zoom_highlight=built in pools#GENERAL