Removes a resource group.
DROP RESOURCE GROUP <group_name>
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
default_group resource groups.
You cannot submit a
DROP RESOURCE GROUP 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:
SELECT usename, current_query, waiting, procpid, rsgid, rsgname, rsgqueueduration FROM pg_stat_activity;
To view the resource group assignments, perform the following query on the
pg_resgroup system catalog tables:
SELECT rolname, rsgname FROM pg_roles, pg_resgroup WHERE pg_roles.rolresgroup=pg_resgroup.oid;
Remove the resource group assigned to a role. This operation then assigns the default resource group
default_group to the role:
ALTER ROLE bob RESOURCE GROUP NONE;
Remove the resource group named
DROP RESOURCE GROUP adhoc;
DROP RESOURCE GROUP statement is a Greenplum Database extension.
Parent topic: SQL Command Reference