Page 1 of 1

Vertica Tip: Predicting the Resources a Statement Needs

Posted: Mon Feb 05, 2018 10:02 pm
by JimKnicely
Vertica Community Blog post authored by Jim Knicely
You may find you want to set up resource pools before running queries to know how many resources a particular query needs. One way to do this is to create a small resource pool, profile the query, and note when the query is rejected. When the query is rejected, Vertica prints the resources that the query needs.

Let’s take a look at an example.

Read more here:
https://my.vertica.com/blog/vertica-tip ... ent-needs/