Skip to main content

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

  • Apr 24, 2017 8:04 AM UTC
  • 1 reply
  • 7 views
ofers

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

    1 reply

    Forum|alt.badge.img+2
    • Anonymous
    • Participating Frequently
    • Apr 25, 2017 3:39 PM UTC

    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)

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement