The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

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?


  • 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