Skip to main content
Any of the following facets of a resource group can be altered, either individually or as a group:
  • Rank
  • Tier limits
  • Execution options
ALTER RESOURCE GROUP Syntax

​
Parameters

<resource group name>

Name of the resource group to alter.

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:
KeywordDescription
FIRSTMake this resource group the new first one in the ordering.
LASTMake 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:
KeywordDescription
tier nameName of the tier to which limits will be assigned:
Name Description
VRAM Update the VRAM tier.
RAM Update the RAM tier.
tier property nameName 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 valueValue 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.

persist

Whether to save this change to the database configuration so that it will stay in effect after a database restart. Default is true.

​
Examples

To alter an existing memory_and_execution resource group, moving it to the highest ranking, while assigning new limits for the RAM tier and max_cpu_concurrency & max_scheduling_priority options, but leaving other existing settings untouched:
ALTER RESOURCE GROUP Example