DROP RESOURCE GROUP

Description

This command removes a resource group from Greenplum Database. 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 Greenplum Database.

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 kills running containers in the group.

You cannot drop the pre-defined and default_group resource groups.

group_name

Notes

You cannot submit a command in an explicit transaction or sub-transaction.

Use ALTER ROLE to remove a resource group assigned to a specific user/role.

Perform the following query to view all of the currently active queries for all resource groups:

To view the resource group assignments, perform the following query on the pg_roles and system catalog tables:

Remove the resource group named :

Compatibility

The DROP RESOURCE GROUP statement is a Greenplum Database extension.

ALTER RESOURCE GROUP, , ALTER ROLE

Parent topic: