blob: 3cf6ed598e2c80e3bf265a782f7a3ff203236659 [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
(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