usage of resource pools

Moderator: NorbertKrupa

Post Reply
xiaoc10
Newbie
Newbie
Posts: 1
Joined: Wed Jul 06, 2016 10:24 pm

usage of resource pools

Post by xiaoc10 » Wed Jul 06, 2016 10:56 pm

We have a 12 Vertica nodes cluster. Each node has 24 cores. I'm testing different settings for resource pool. Two settings are like following:

CREATE RESOURCE POOL parallel_24
EXECUTIONPARALLELISM 24;

CREATE RESOURCE POOL parallel_6
EXECUTIONPARALLELISM 6;

And then I run a test query using these two resource pools separately and then use the following query to verify the test query does use the correct resource pool.

SELECT * FROM query_profiles, resource_acquisitions
where resource_acquisitions.transaction_id = query_profiles.transaction_id and
resource_acquisitions.statement_id = query_profiles.statement_id and
query_profiles.transaction_id=94575592175788847 and
query_profiles.statement_id = 1

I list part of columns generated by the above query:

pool_name thread_count duration_ms
parallel_24 356 3500

pool_name thread_count duration_ms
parallel_6 362 9000

From the above result, we can clearly see that increasing the parallelism reduce the running time. But I did not understand the thread_count from two aspects: (1) why there are so many threads involved? (2) parallel_6 even has more threads than parallel_24? (3) what does thread_count really mean?

Thanks,

Post Reply

Return to “Vertica Database Administration”