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'; maxmemorysize --------------- Special: 95% (1 row)
Refer to:https://www.vertica.com/docs/9.3.x/HTML/Content/Authoring/SQLReferenceManual/Statements/Built-inPools.htm?zoom_highlight=built in pools#GENERAL
Answers
By default Vertica will use 95% of total physical RAM on the machine that the Resource Manager can use for queries.
Refer to:
https://www.vertica.com/docs/9.3.x/HTML/Content/Authoring/SQLReferenceManual/Statements/Built-inPools.htm?zoom_highlight=built in pools#GENERAL