Slow query execution
Currently, we are building a Vertica server with the following configuration
Number of servers: 3
Number of CPU cores per server: 16
It uses only about four cores per server when performing complex queries, and
If you look at v_monitor.cpu_usage, it is only using about 20 percent of the peak time.
To use more CPU resources during query execution to reduce execution time, you can use
What should I do?
If this is possible by changing the settings, please tell me how to do it.
(The query itself is very inefficient.
Since the creation of the query is done by the user, query modification is considered a last resort)