CREATE RESOURCE GROUP - Kinetica Docs

Resource groups require only a name to be created, all limits are optional. Resource group names are case-sensitive and must contain only letters, digits, and underscores, and cannot begin with a digit. A resource group must also not be named the same as an existing resource group, including the default resource groups: kinetica_system_resource_group & kinetica_default_resource_group.

CREATE RESOURCE GROUP Syntax

CREATE RESOURCE GROUP <resource group name>
[ RANK <FIRST | LAST | BEFORE <group name> | AFTER <group name>> ]
[
    TIER LIMITS
    (
        <tier name> USING (<tier property name> = <tier property value>[,...]),
        ...
        <tier name> USING (<tier property name> = <tier property value>[,...])
    )
]
[ WITH OPTIONS (<resource property name> = <resource property value>[,...]) ]

Parameters

Name of the resource group to create.

RANK

Designation of where in the ordering of applicable resource groups this one should exist. For a given set of resource groups, the one that is ranked before all the others will be used.RANK designations include:

Keyword	Description
`FIRST`	Make this resource group the new first one in the ordering.
`LAST`	Make this resource group the new last one in the ordering.
`BEFORE <group name>`	Place this resource group before the one specified by `group name` in the ordering.
`AFTER <group name>`	Place this resource group after the one specified by `group name` in the ordering.

TIER LIMITS

Optional indicator that a set of tier names and corresponding property assignments will follow.Parameters for each tier assignment are as follows:

Keyword Description

tier name

Name of the tier to which limits will be assigned:

Name	Description
`VRAM`	Configure the VRAM tier.
`RAM`	Configure the RAM tier.

tier property name

Name of the tier property to which a limit will be assigned:

Property	Description
`max_memory`	Maximum amount of memory per rank per GPU that can be used in the VRAM tier, or maximum amount of memory per rank that can be used in the RAM tier.

tier property value Value to assign the corresponding tier property.

WITH OPTIONS

Optional indicator that a comma-delimited list of resource group property option/value assignments will follow.See Options for the complete list of options.

Options

The following options can be specified to further modify a resource group configuration.

max_cpu_concurrency

Maximum number of simultaneous threads that will be used to execute a request, per rank. Must be >= 4.

max_data

Maximum amount of data, per rank, in bytes, that can be used by all database objects within this group; for example, a max_data of 1000000000 would limit a user with this resource group to a per-rank total of 1GB of data usage across all tables, views, graphs, etc., including temporary objects supporting data processing operations (queries, materialized views, etc.).

max_scheduling_priority

Maximum scheduling priority of a task.

max_tier_priority

Maximum eviction priority of a tiered object.

Examples

To create a simple unlimited resource group with default settings:

CREATE RESOURCE GROUP Example

CREATE RESOURCE GROUP unlimited

To create a memory_over_execution resource group, with high tier capacity limits, but low execution options:

CREATE RESOURCE GROUP with Tier Limits & Options Example

CREATE RESOURCE GROUP memory_over_execution
TIER LIMITS
(
    VRAM USING (max_memory = 10737418240),
    RAM USING (max_memory = 107374182400)
)
WITH OPTIONS
(
    max_cpu_concurrency = 5,
    max_scheduling_priority = 30,
    max_tier_priority = 4
)

To create a execution_over_memory resource group, with lower tier capacity limits, but higher execution options, as compared to the memory_over_execution group:

CREATE RESOURCE GROUP with Ranking Example

CREATE RESOURCE GROUP execution_over_memory
RANK BEFORE memory_over_execution
TIER LIMITS
(
    VRAM USING (max_memory = 1073741824),
    RAM USING (max_memory = 10737418240)
)
WITH OPTIONS
(
    max_cpu_concurrency = 7,
    max_scheduling_priority = 70,
    max_tier_priority = 10
)

​Parameters

​Options

​Examples

Parameters

Options

Examples