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.

Note

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.

In this section

Basic principles for scalability and concurrency tuning
Setting a runtime limit for queries
Handling session socket blocking
Managing workloads with resource pools and user profiles
Tuning built-in pools
Reducing query run time
Managing workload resources in an Eon Mode database