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!

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

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

  • [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
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file