Question

How much memory does Vertica use with no configuration?

What is the maximum amount of memory a Vertica database would use out of the box (no configuration) ?
@bat @rbankula

+2

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)

Sign up