We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


General Resource Pool - Memory Allocation — Vertica Forum

General Resource Pool - Memory Allocation

ersaurabhexersaurabhex - Select Field - ✭
in General Discussion

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?

Comments

  • DaveTDaveT Vertica Employee Employee

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

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...