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.

images/resource_group_general.png

Use the fields on the General tab to specify resource group attributes:

  • Use the Name field to add a descriptive name for the resource group. This name will be displayed in the tree control.
  • Use the CPU rate limit (%) field to set the value of the CPU rate limit resource type assigned to the resource group. The valid range for a CPU rate limit is from 0 to 1.67772e+07. The default value is 0.
  • Use the Dirty rate limit (KB) field to set the value of the dirty rate limit resource type assigned to the resource group. The valid range for a dirty rate limit is from 0 to 1.67772e+07. The default value is 0.

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:

images/resource_group_sql.png

The example creates a resource group named acctg that sets cpu_rate_limit to 2 , and dirty_rate_limit to 6144 .

  • Click the Info button ( i ) to access online SQL syntax reference material.
  • Click the Help button ( ? ) to access online documentation about Resource Groups.
  • Click the Save button to save work.
  • Click the Cancel button to exit without saving work.
  • Click the Reset button to restore configuration parameters.