Skip to main content
Question

per query memory restriction?

  • January 25, 2019
  • 5 replies
  • 14 views
Vertica_Curtis
Forum|alt.badge.img+1

Is there a way to restrict the amount of memory a single query can consume?

For example, say I have a resource pool with a number of queries running and everything works well - but then occasionally a query shows up with a lot of joins and chews up 120Gb of RAM by itself. This ends up starving everything else in the pool. Is there a way to restrict how much that single query can get without modifying the overall resource pool values?

    5 replies

    chaima
    Forum|alt.badge.img+2
    • chaima
    • Participating Frequently
    • January 25, 2019
    Hi Curtis,
    Would setting MAXQUERYMEMORYSIZE without changing the other RP parameters help?
    Chaima
    DaveT
    Forum|alt.badge.img
    • DaveT
    • Participating Frequently
    • January 25, 2019

    This might not be what you want but you can set the MAXQUERYMEMORYSIZE in the resource pool if you are at 9.1. It was designed to help with what you are talking about.

    Vertica_Curtis
    Forum|alt.badge.img+1
    • Vertica_Curtis
    • Author
    • Participating Frequently
    • January 25, 2019

    That sounds perfect. Where is it? I don't see anything even remotely close to that in either confguration_parameters or vs_configuration_parameters.

    Jim_Knicely
    Forum|alt.badge.img+2
    • Jim_Knicely
    • Participating Frequently
    • January 25, 2019

    It is a resource pool parameter.

    See:
    https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/SQLReferenceManual/Statements/Built-inPoolConfiguration.htm

    Vertica_Curtis
    Forum|alt.badge.img+1
    • Vertica_Curtis
    • Author
    • Participating Frequently
    • January 25, 2019

    Apparently I need to upgrade my sandbox. Looks like they added this in 9.1. That's cool. Sounds like yet another for Domo to upgrade.

    Thanks

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement