Version: 2.x
DROP RESOURCE GROUP
Removes a resource group.
Synopsis
DROP RESOURCE GROUP <group_name>
Description
This command removes a resource group from Apache Cloudberry. Only a superuser can drop a resource group. When you drop a resource group, the memory and CPU resources reserved by the group are returned to Apache Cloudberry.
To drop a role resource group, the group cannot be assigned to any roles, nor can it have any statements pending or running in the group. If you drop a resource group that you created for an external component, the behavior is determined by the external component. For example, dropping a resource group that you assigned to a PL/Container runtime stops running containers in the group.
You cannot drop the pre-defined admin_group and default_group resource groups.