blob: d6e39e817821a27d5451ae293fcbeae8f2d9f1e8 [file] [log] [blame]
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
rg1 | 0
rg2 | 0
(5 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
rg1
rg2
(5 rows)
select rsgname from gp_toolkit.gp_resgroup_status
where rsgname not like 'rg_dump_test%'
order by groupid;
rsgname
---------
(0 rows)
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
alter resource group rg2 set cpu_max_percent 20;
alter resource group rg2 set cpu_max_percent 10;