The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

EXECUTIONPARALLELISM in resource Pool

Whats does it mean EXECUTIONPARALLELISM? and how we can set it?
Why it is required?

Comments

  • EXECUTIONPARALLELISM – imposes a limit on the maximum number of threads that any single request can use.
    Use this parameter to limit the number of threads that would be used to process any single query issued in this resource pool.
    Reducing this parameter may increase the throughput of short queries issued in the pool, especially if the queries are executed concurrently. If you choose the default of AUTO, Vertica sets this value for you.
    If you choose to manually set this parameter, set it to a value between 1 and the number of cores.
    Run the below query to set the executionparallelism.
    Syntax)
    ALTER RESOURCE POOL pool‑name [ parameter‑name setting ]…
    ex)
    ALTER RESOURCE POOL recovery executionparallelism 10;
    ALTER RESOURCE POOL

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.