Understanding Vertica Query Budgets

Soniya Shah, Information Developer
June 13, 2018

This blog post was authored by Shrirang Kamat. The purpose of this document is to explain how the query budget of a resource pool used by the query can influence the initial memory acquisition for a query and how it impacts query performance. For more details about how we compute the query budget, see the...
Three 3D arrows, different colors pointing in different directions

Which One of these Nodes Doesn’t Belong? A Vertica Quick Tip

Sarah Lemaire, Manager, Vertica Documentation
June 13, 2018

Jim Knicely wrote this tip. We strongly recommend that you use a homogeneous hardware configuration for your Vertica cluster: Each node of the cluster should be similar in CPU, clock speed, number of cores, memory, and operating system version. We learned in the last Vertica Quick Tip that the V_CATALOG.HOST_RESOURCES system table provides a snapshot...