DROP RESOURCE GROUP

A newer version of this documentation is available. Use the version menu above to view the most up-to-date release of the Greenplum 5.x documentation.

DROP RESOURCE GROUP

Removes a resource group.

Synopsis

DROP RESOURCE GROUP group_name

Description

This command removes a resource group from Greenplum Database. Only a superuser can drop a resource group.

To drop a resource group, the group cannot be assigned to any roles, nor can it have any statements pending or running in the group.

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

Parameters

group_name
The name of the resource group to remove.

Notes

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

Use ALTER ROLE to remove the 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_roles and pg_resgroup system catalog tables:

SELECT rolname, rsgname 
  FROM pg_roles, pg_resgroup
  WHERE pg_roles.rolresgroup=pg_resgroup.oid;

Examples

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 adhoc:

DROP RESOURCE GROUP adhoc;

Compatibility

The DROP RESOURCE GROUP statement is a Greenplum Database extension.