| show gp_resource_manager; |
| gp_resource_manager |
| --------------------- |
| queue |
| (1 row) |
| |
| select rsgname, parent from pg_resgroup |
| where rsgname not like 'rg_dump_test%' |
| order by oid; |
| rsgname | parent |
| ---------------+-------- |
| default_group | 0 |
| admin_group | 0 |
| system_group | 0 |
| (3 rows) |
| |
| select avg(reslimittype) |
| from pg_resgroupcapability |
| where reslimittype <= 1; |
| avg |
| ------------------------ |
| 1.00000000000000000000 |
| (1 row) |
| |
| select groupname from gp_toolkit.gp_resgroup_config |
| where groupname not like 'rg_dump_test%' |
| order by groupid; |
| groupname |
| --------------- |
| default_group |
| admin_group |
| system_group |
| (3 rows) |
| |
| select rsgname from gp_toolkit.gp_resgroup_status |
| where rsgname not like 'rg_dump_test%' |
| order by groupid; |
| rsgname |
| --------- |
| (0 rows) |
| |
| create resource group rg1 with (cpu_max_percent=10, memory_quota=10); |
| WARNING: resource group is disabled |
| HINT: To enable set gp_resource_manager=group |
| alter resource group rg1 set cpu_max_percent 20; |
| alter resource group rg1 set cpu_max_percent 10; |
| drop resource group rg1; |
| create resource group rg1 with (cpu_max_percent=10, memory_quota=10); |
| WARNING: resource group is disabled |
| HINT: To enable set gp_resource_manager=group |
| create resource group rg2 with (cpu_max_percent=10, memory_quota=10); |
| WARNING: resource group is disabled |
| HINT: To enable set gp_resource_manager=group |