Help Center/ GaussDB/ Developer Guide(Centralized_V2.0-8.x)/ SQL Reference/ SQL Syntax/ A/ ALTER SYSTEM SET
Updated on 2025-05-29 GMT+08:00
View PDF
Share

ALTER SYSTEM SET

Description

When the multi-tenancy feature is enabled, you can run this command in a non-PDB (such as the postgres database) to switch resource plans.

Precautions

  • This command can be used only by the initial user and users with the SYSADMIN permission.
  • This command cannot be executed in a PDB.
  • This command cannot be executed in M-compatible databases.

Syntax

ALTER SYSTEM SET resource_manager_plan TO plan_name;

Parameters

  • plan_name

    Specifies the name of a resource plan.

Examples

-- Connect to the postgres database and set the current resource plan to default_resource_plan. The new resource plan takes effect immediately.
gaussdb=# ALTER SYSTEM SET RESOURCE_MANAGER_PLAN TO 'default_resource_plan';
ALTER SYSTEM SET
Parent topic: A