Vertica Tip: Predicting the Resources a Statement Needs

Moderator: NorbertKrupa

Post Reply
User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1825
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Vertica Tip: Predicting the Resources a Statement Needs

Post by JimKnicely » Mon Feb 05, 2018 10:02 pm

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/
Jim Knicely

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “Vertica Links”