Whats does it mean EXECUTIONPARALLELISM? and how we can set it?
Why it is required?
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.
ALTER RESOURCE POOL pool‑name [ parameter‑name setting ]…
ALTER RESOURCE POOL recovery executionparallelism 10;
ALTER RESOURCE POOL
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.