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?

Answers

  • SruthiASruthiA Employee

    Execution Parallelism Limits the number of threads used to process any single query issued in a resource pool. It can be set using ALTER RESOURCE POOL statement for a particular resource pool. Default is AUTO which is equal to number of cores of your system. It is used to provide more threads to a query so that it can complete quickly. However it is not ideal to increase EXECUTIONPARALLELISM to high value

    if your query has a GROUP BY clause and EXECUTIONPARALLELISM is set to 8, to perform GROUP BY operation vertica will use 8 threads. Since it uses many threads it requires more memory. So you need to have enough memory available in that resource pool where the query is running.

    The below blog provides a good picture of Vertica's work load management and how concurrency and parallelism effects workloads

    https://www.vertica.com/blog/concurrency-workload-management/

  • If we can leave it as default for our user-defined pool than there should be not a problem?

  • SruthiASruthiA Employee

    Yes. You can leave it at default which is AUTO. there should not be any issue.

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.