Options

Memory pool warning: static OPT::Plan* OPT::OptimizerInterface:

ofersofers ✭
in General Discussion

Hi,

We're seeing these on our logs quite a bit:

[Basics] MemoryPool static OPT::Plan* OPT::OptimizerInterface::makePlan(CAT::VQuery*, OPT::OptimizerConfig&) is using more memory than allowed.

I've been trying to find reference to this warning message, but was unable to discover much about it.

Does anyone have an idea where I can learn more about this?

Thanks,

Ofer

Comments

  • Options
    [Deleted User][Deleted User] Administrator

    This error is seen when Vertica optimizer needs more than 100MB to plan a query. Max memory allowed for a planning a query is controled by configuration parameter MaxOptMemMB. You can increase it by using set_config_parameter API .

    MaxOptMemMB- Maximum amount of memory used by the Optimizer; Increasing this value may help with 'Optimizer memory use exceeds allowed limit' errors (MB)

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