The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
Performance of parallel execution time of query to flex table
When you run a parallel query to flex table, At this time, all processing is slow.
For example, two queries execute,
1 query about 100sec,
2 queries about 200sec/query, Much as both.
At this time, there is a margin in cpu utilization.
and
When to parallel processing of a single query to flextable can be slow,
EXECUTIONPARALLELISM=30 180sec CPU Usage 3000%
EXECUTIONPARALLELISM=5 95sec CPU Usage 500%
EXECUTIONPARALLELISM=1 58sec CPU Usage 100%
EXECUTIONPARALLELISM=1 is fastest and CPU usage is the lowest!
Test environment spec
5node cluster(cpu 32, mem 128GB, HDD 12TB)
For example, two queries execute,
1 query about 100sec,
2 queries about 200sec/query, Much as both.
At this time, there is a margin in cpu utilization.
and
When to parallel processing of a single query to flextable can be slow,
EXECUTIONPARALLELISM=30 180sec CPU Usage 3000%
EXECUTIONPARALLELISM=5 95sec CPU Usage 500%
EXECUTIONPARALLELISM=1 58sec CPU Usage 100%
EXECUTIONPARALLELISM=1 is fastest and CPU usage is the lowest!
Test environment spec
5node cluster(cpu 32, mem 128GB, HDD 12TB)
0