resource-pool-cpu-affinity-set.md
Specifies which CPUs are available to this resource pool. All cluster nodes must have the same number of CPUs. The CPU resources assigned to this set are unavailable to general resource pools.
CPUAFFINITYSET {
'cpu-index[,...]'
| 'cpu-indexi-cpu-indexn'
| 'integer%'
| NONE
}
-
cpu-index[,...]: Dedicates one or more comma-delimited CPUs to this pool. -
**``*cpu-indexi*-*cpu-index*n**: Dedicates a range of contiguous CPU indexes to this pool -
integer%: Percentage of all available CPUs to use for this pool. Vertica rounds this percentage down to include whole CPU units. -
NONE(default): No affinity set is assigned to this resource pool. The queries associated with this pool are executed on any CPU.
Important
CPUAFFINITYSET and CPUAFFINITYMODE must be set together in the same statement.