General Resource Pool - Memory Allocation

ersaurabhexersaurabhex - Select Field -

I have three node cluster of 64GB RAM Each. As mentioned using below query.

Select processor_core_count, processor_description, total_memory_bytes from HOST_RESOURCES;
processor_core_count processor_description total_memory_bytes
16 Intel(R) Xeon(R) CPU E5-2667 v2 @ 3.30GHz 67,336,785,920
16 Intel(R) Xeon(R) CPU E5-2667 v2 @ 3.30GHz 67,335,409,664
16 Intel(R) Xeon(R) CPU E5-2667 v2 @ 3.30GHz 67,336,105,984

No user defined pools are created.
select name,memorysize,maxmemorysize from resource_pools;

name memorysize maxmemorysize

1 general Special: 95%
2 sysquery 64M
3 sysdata 100M 1G
4 wosdata 2G 2G
5 tm 200M
6 refresh 0%
7 recovery 0%
8 dbd 0%
9 jvm 0% 2G
10 blobdata 0% 10%
11 metadata 0%

My default General Pool with 95% allocation of max memory is showing only 22GB. What could be the reason and how to fix it?


  • Options
    DaveTDaveT Vertica Employee Employee

    What are you viewing that indicates 22G? What does the following return?

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file