Built-In Pool Configuration

The tables in this section list the default configuration settings for the Vertica built-in resource pools:

GENERAL
BLOBDATA
DBD
JVM
METADATA
RECOVERY
REFRESH
SYSDATA
SYSQUERY
TM
WOSDATA

Some built-in resource pool parameter values have restrictions, which are noted in the tables. For guidance about how to tune the General resource pool, see Best Practices for Managing Workload Resources in the Administrator's Guide.

GENERAL

Setting	Value
`MEMORYSIZE`	N/A (cannot be set)
`MAXMEMORYSIZE`	Sets the maximum memory to use for all resource pools. Specify this value as a percentage of total RAM. For example, if your node has 64GB of memory, setting MAXMEMORYSIZE to 50% allocates half of the available memory. The total memory for all resource pools cannot exceed 32GB. Setting this parameter to 100% generates warning messages that swapping could result. Changing the MAXMEMORYSIZE parameter has the following restrictions: Must be 1GB or greater. Cannot be less than 25% of total system RAM. Default: 95%, with minimum of 25% (at least 1GB), maximum 100%
`PRIORITY`	0
`RUNTIMEPRIORITY`	Medium
`RUNTIMEPRIORITYTHRESHOLD`	2
`QUEUETIMEOUT`	300
`RUNTIMECAP`	NONE
`PLANNEDCONCURRENCY`	An integer representing the number of concurrent queries you expect to run against the resource pool. When set to the default value of AUTO, Vertica automatically sets PLANNEDCONCURRENCY at query runtime, choosing the lower of these two values: Number of cores Memory/2GB The value 4 is the minimum value for PLANNEDCONCURRENCY. For systems with a large number of cores, the `PLANNEDCONCURRENCY` setting for the `GENERAL` pool defaults to a value that is too low. For this configuration, Vertica recommends adjusting to a value equaling the number of cores: ALTER RESOURCE POOL general PLANNEDCONCURRENCY <#cores>; Default: AUTO
`MAXCONCURRENCY`	Unlimited Restrictions: Setting to 0 generates warnings that no system queries may be able to run in the system.
`SINGLEINITIATOR`	False. This parameter is included for backwards compatibility only. Do not change the value.

BLOBDATA

Setting	Value
`MEMORYSIZE`	0%
`MAXMEMORYSIZE`	Unlimited
`EXECUTIONPARALLELISM`	N/A (cannot be set)
`PRIORITY`	N/A (cannot be set)
`RUNTIMEPRIORITY`	N/A (cannot be set)
`RUNTIMEPRIORITYTHRESHOLD`	N/A (cannot be set)
`QUEUETIMEOUT`	N/A (cannot be set)
`RUNTIMECAP`	NONE
`PLANNEDCONCURRENCY`	2
`MAXCONCURRENCY`	N/A (cannot be set)
`SINGLEINITIATOR`	N/A (cannot be set)

DBD

Setting	Value
`MEMORYSIZE`	0%
`MAXMEMORYSIZE`	Unlimited
`EXECUTIONPARALLELISM`	AUTO
`PRIORITY`	0
`RUNTIMEPRIORITY`	MEDIUM
`RUNTIMEPRIORITYTHRESHOLD`	0
`QUEUETIMEOUT`	0
`RUNTIMECAP`	NONE
`PLANNEDCONCURRENCY`	See `GENERAL`
`MAXCONCURRENCY`	Unlimited
`SINGLEINITIATOR`	False. This parameter is included for backwards compatibility. Do not change the value.

JVM

Setting	Value
`MEMORYSIZE`	0%
`MAXMEMORYSIZE`	10% of memory or 2 GB, whichever is smaller
`EXECUTIONPARALLELISM`	AUTO
`PRIORITY`	0
`RUNTIMEPRIORITY`	MEDIUM
`RUNTIMEPRIORITYTHRESHOLD`	2
`QUEUETIMEOUT`	300
`RUNTIMECAP`	NONE
`PLANNEDCONCURRENCY`	AUTO
`MAXCONCURRENCY`	N/A (cannot be set)
`SINGLEINITIATOR`	FALSE. This parameter is included for backwards compatibility. Do not change the value.

METADATA

Setting	Value
`MEMORYSIZE`	0%
`MAXMEMORYSIZE`	Unlimited
`EXECUTIONPARALLELISM`	N/A (cannot be set)
`PRIORITY`	N/A (cannot be set)
`RUNTIMEPRIORITY`	N/A (cannot be set)
`RUNTIMEPRIORITYTHRESHOLD`	N/A (cannot be set)
`QUEUETIMEOUT`	N/A (cannot be set)
`PLANNEDCONCURRENCY`	N/A (cannot be set)
`MAXCONCURRENCY`	N/A (cannot be set)
`SINGLEINITIATOR`	FALSE. This parameter is included for backwards compatibility. Do not change the value.
`CPUAFFINITYSET`	N/A (cannot be set)
`CPUAFFINITYMODE`	N/A (cannot be set)

RECOVERY

Setting	Value
`MEMORYSIZE`	0%
`MAXMEMORYSIZE`	Unlimited Restrictions: cannot set to < 25%.
`EXECUTIONPARALLELISM`	AUTO
`PRIORITY`	107
`RUNTIMEPRIORITY`	MEDIUM
`RUNTIMEPRIORITYTHRESHOLD`	60
`QUEUETIMEOUT`	300
`RUNTIMECAP`	NONE
`PLANNEDCONCURRENCY`	Twice `MAXCONCURRENCY`
`MAXCONCURRENCY`	(# of cores / 2) + 1 Restrictions: Cannot set to 0 or NONE (unlimited)
`SINGLEINITIATOR`	True. This parameter is included for backwards compatibility. Do not change the value.

REFRESH

Setting	Value
`MEMORYSIZE`	0%
`MAXMEMORYSIZE`	Unlimited
`EXECUTIONPARALLELISM`	AUTO
`PRIORITY`	-10
`RUNTIMEPRIORITY`	MEDIUM
`RUNTIMEPRIORITYTHRESHOLD`	60
`QUEUETIMEOUT`	300
`RUNTIMECAP`	NONE
`PLANNEDCONCURRENCY`	4 Note: `PLANNEDCONCURRENCY` for the `REFRESH` pool is always set to 4 by default (the `AUTO` setting). For some of the resource pools other than `REFRESH`, `PLANNEDCONCURRENCY` is set according to a formula that considers your hardware configuration. `PLANNEDCONCURRENCY` for `REFRESH` does not consider hardware as the default setting is always 4. You can change the default setting of `PLANNEDCONCURRENCY` with the `ALTER RESOURCE POOL` statement.
`MAXCONCURRENCY`	Unlimited Restrictions: cannot set to 0
`SINGLEINITIATOR`	True. This parameter is included for backwards compatibility. Do not change the value.

SYSDATA

Setting	Value
`MEMORYSIZE`	100m
`MAXMEMORYSIZE`	10% Restriction: Setting To <4m generates warnings that no system queries may be able to run in the system.
`EXECUTIONPARALLELISM`	N/A (cannot be set)
`PRIORITY`	N/A (cannot be set)
`RUNTIMEPRIORITY`	N/A (cannot be set)
`RUNTIMEPRIORITYTHRESHOLD`	N/A (cannot be set)
`QUEUETIMEOUT`	N/A (cannot be set)
`RUNTIMECAP`	N/A (cannot be set)
`PLANNEDCONCURRENCY`	N/A (cannot be set)
`MAXCONCURRENCY`	N/A (cannot be set)
`SINGLEINITIATOR`	N/A (cannot be set)

SYSQUERY

Setting	Value
`MEMORYSIZE`	64M Restrictions: Setting to <20M generates warnings because it could prevent system queries from running and make problem diagnosis difficult.
`MAXMEMORYSIZE`	Unlimited
`EXECUTIONPARALLELISM`	AUTO
`PRIORITY`	110
`RUNTIMEPRIORITY`	HIGH
`RUNTIMEPRIORITYTHRESHOLD`	0
`QUEUETIMEOUT`	300
`RUNTIMECAP`	NONE.
`PLANNEDCONCURRENCY`	See `GENERAL`
`MAXCONCURRENCY`	Unlimited Restrictions: Setting to 0 generates warnings that no system queries may be able to run in the system.
`SINGLEINITIATOR`	False. This parameter is included for backwards compatibility only. Do not change the value.

TM

Setting	Value
`MEMORYSIZE`	100M
`MAXMEMORYSIZE`	Unlimited
`EXECUTIONPARALLELISM`	AUTO
`PRIORITY`	105
`RUNTIMEPRIORITY`	MEDIUM
`RUNTIMEPRIORITYTHRESHOLD`	60
`QUEUETIMEOUT`	300
`RUNTIMECAP`	NONE
`PLANNEDCONCURRENCY`	1
`MAXCONCURRENCY`	2 Restrictions: Cannot set to 0 or NONE (unlimited)
`SINGLEINITIATOR`	True. This parameter is included for backwards compatibility. Do not change the value.

WOSDATA

Setting	Value
`MEMORYSIZE`	0%
`MAXMEMORYSIZE`	25% or 2GB of the `GENERAL` pool's limits, whichever is less. When the `GENERAL` pool's memory limits are 20GB or greater, the `WOSDATA` pool will instead have a dedicated 2GB of memory.
`EXECUTIONPARALLELISM`	N/A (cannot be set)
`PRIORITY`	N/A (cannot be set)
`RUNTIMEPRIORITY`	N/A (cannot be set)
`RUNTIMEPRIORITYTHRESHOLD`	N/A (cannot be set)
`QUEUETIMEOUT`	N/A (cannot be set)
`RUNTIMECAP`	NONE
`PLANNEDCONCURRENCY`	2
`MAXCONCURRENCY`	N/A (cannot be set)
`SINGLEINITIATOR`	N/A (cannot be set)