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 PoolsA 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 ParametersEvery resource pool has a set of customizable parameters. For more information, see Monitoring Resource Pools.
Learn MoreFor more information about managing resources and resource pools, see:
- Managing Workloads in the Vertica documentation