myVertica  

Managing Workloads with Resource Pools

Vertica provides a sophisticated resource management scheme that allows diverse, concurrent workloads to run efficiently on the database. Data loads and queries consume resources like CPU, memory, disk I/O, and network bandwidth. Query performance depends on how many resources they use during execution.

Resource Pools

A resource pool is a pre-allocated subset of system resources. All resource pools are associated with a queue of queries that will be executed against it. Vertica provides built-in resource pools for executing queries. You can also create your own resource pools if your workload requires it. For more information, see Resource Pool Architecture in the Vertica documentation.

Resource Pool Parameters

Every resource pool has a set of customizable parameters. For more information, see Monitoring Resource Pools.

Learn More

For more information about managing resources and resource pools, see: