Built-In Pool Configuration

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

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)

 


Was this topic helpful?