This operation mode is used to set up permanent resource prioritization plans for users or roles. These plans remain unchanged regardless of the time of the day, the day of the week, etc. You don't have to create and set up plan assignment groups for users or roles. In other words, only the preinstalled default group is used implicitly.

This mode includes the following steps:

The created plans can be updated or deleted if needed.

Example:

        -- Create resource prioritization plans
        SELECT pgpro_rp_create_plan('plan_2_2_2', 2, 2, 2);
        SELECT pgpro_rp_create_plan('plan_8_8_8', '{ "session_cpu_weight":8,
        "session_ioread_weight":8, "session_iowrite_weight":8}');

        -- Assign plans to roles
        SELECT pgpro_rp_create_role_plan('users', 'plan_2_2_2');
        SELECT pgpro_rp_create_role_plan('admins', 'plan_8_8_8');
      

This operation mode is used to set up various resource prioritization plans for users or roles that are subject to changing in accordance with the time of the day, the day of the week, etc.

This mode includes the following steps:

Example:

        -- Create resource prioritization plans
        SELECT pgpro_rp_create_plan('plan_8_8_8', 8, 8, 8);
        SELECT pgpro_rp_create_plan('plan_4_4_4', 4, 4, 4);
        SELECT pgpro_rp_create_plan('plan_2_2_2', 2, 2, 2);
        SELECT pgpro_rp_create_plan('plan_1_1_1', 1, 1, 1);

        -- Create plan assignment groups to users or roles and add in plan assignment groups
        SELECT pgpro_rp_create_group('day_plan');
        SELECT pgpro_rp_create_group_role_plan('day_plan', 'top', 'plan_4_4_4');
        SELECT pgpro_rp_create_group_role_plan('day_plan', 'main', 'plan_2_2_2');
        SELECT pgpro_rp_create_group_role_plan('day_plan', 'hr', 'plan_1_1_1');

        SELECT pgpro_rp_create_group('night_plan');
        SELECT pgpro_rp_create_group_role_plan('night_plan', 'top', 'plan_8_8_8');
        SELECT pgpro_rp_create_group_role_plan('night_plan', 'main', 'plan_1_1_1');
        SELECT pgpro_rp_create_group_role_plan('night_plan', 'hr', 'plan_2_2_2');

        -- Set an active group
        CALL pgpro_rp_set_active_group('day_plan');
      

The functions described in this section provide the ability to create, modify, or delete a resource prioritization plan.

The functions described in this section provide the ability to manage plan assignment groups for users or roles.

The functions described in this section provide the ability to manage plan assignment for roles.

The following functions work with an active plan assignment group specified in the pgpro_rp_options table:

Functions to add/delete in plan assignment groups for users or roles:

Other functions:

You can declare a custom function to select resource prioritization plans, which takes no arguments and returns the plan ID, to be called at the session start using the functions described below.

When creating any session, the prioritization parameter values from the assigned plan are applied to this session. However, searching for a plan requires certain resources (you need to read data from several tables), so the values of user prioritization parameters are cached in shared memory. If you create another session, its user will be searched in the cache, and if the user is found, the values of the prioritization parameters stored in the cache will be applied to the newly created session. Since the values in the cache may expire, the following function is provided to clear the cache:

This function should be called in cases where user prioritization settings may change (assigning roles to users, changing the parameters of the active group/plans in use, etc.).