Use the Resource Group dialog to create a resource group and set values for its resources. A resource group is a named, global group on which various resource usage limits can be defined. The resource group is accessible from all databases in the cluster. To use the Resource Group dialog, you must have superuser privileges. Please note that resource groups are supported when connected to EDB Postgres Advanced Server; for more information about using resource groups, please see the EDB Postgres Advanced Server Guide, available at:
Fields used to create a resource group are located on the General tab. The SQL tab displays the SQL code generated by your selections on the Resource Group dialog.
Use the fields on the General tab to specify resource group attributes:
Click the SQL tab to continue.
Your entries in the Resource Group dialog generate a SQL command. Use the SQL tab for review; revisit the General tab to make any changes to the SQL command.
Example
The following is an example of the sql command generated by selections made in the Resource Group dialog:
The example creates a resource group named acctg that sets cpu_rate_limit to 2, and dirty_rate_limit to 6144.