Best Practices for Managing Workload Resources
This section provides general guidelines and best practices on how to set up and tune resource pools for various common scenarios.
The exact settings for resource pool parameters are heavily dependent on your query mix, data size, hardware configuration, and concurrency requirements. Vertica recommends performing your own experiments to determine the optimal configuration for your system.