NewEEThread vs Plannedconcurrency

[nnani]

while going through Vertica configuration parameters table, I found these two parameters

1. NewEEThread : Number of threads the EE will attempt to use for processing (per plan)
2. SortWorkerThreads : Controls the number of Sort worker threads; 0 disables background threads

According to description , I am a bit confused on where does this parameter come int picture while query execution.

Also, Is there any co-relation between NewEEThread and Plannedconcurrency from resource pools, I know plannedconcurrency can be set for different resource pool, but what part does NewEEThread do here ?

Also some more insights into both these paramters.

Thanks

[id10t]

Hi!

[DELETED]

[JimKnicely]

In the "Advanced Projection Design" course at the Vertica Big Data Conference the presenter said that Vertica uses the "Quicksort".

[id10t]

Hi!

[DELETED]

[scutter]

There’s no need to ever touch NewEEThread. If you want to affect the number of threads/cores used by a query, these days you would use the EXECUTIONPARALLELISM setting for each resource pool.

—Sharon