The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
emoreno · Employee
- Last Active
- Vertica Employee, Member, VerticaExpert
One of the thing that you can do is to put the COPY command in a specific pool and give it a big query budget. You can see the query_budget in resource_pool_status. Hope this helps, Eugenia (View Post)1
For what I see in the graph you are also running more queries in NODE05 compared to the others. Do you have a load balancer? With a query like this you can verify how many queries you run in each of … (View Post)1
In the query profiles table you have query_type that tells if it is a DDL what was executed. However, this data is phase out depending on your data collector setting. You could capture the info in a … (View Post)1
you don't need to change the license with the install script, you can do it in admintools in the advance menu. The license is a text file, the community license you can find it in /opt/vertica/config… (View Post)1