Can't change maxmemorysize in the general pool

David_MartiDavid_Marti
in General Discussion
I need to change the maxmemorysize value of the general pool. When I issue the command:ALTER RESOURCE POOL general MAXMEMORYSIZE '60%'; I get a response of:NOTICE 2585: Change takes effect upon restart. Recovering nodes will use the new value ALTER RESOURCE POOL. I have tried restarting the database via admintools, shutting down and restarting verticad, vertica_agent, spreadd and rebooted the machine all to no avail. The select command still returns a value of Special: 95%. I am running as dbadmin which is set to is_super_user true.

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 ...