pg_default resource queue

Post date: Dec 03, 2014 2:15:4 AM

pg_default is the default resource queue created when you install the greenplum database. pg_default resource queue has an active statement limit of 20, no cost limit, no memory limit, and a medium priority setting.

sachi=# select * from pg_catalog.pg_resqueue where rsqname='pg_default';

rsqname | rsqcountlimit | rsqcostlimit | rsqovercommit | rsqignorecostlimit

------------+---------------+--------------+---------------+--------------------

pg_default | 20 | -1 | f | 0

(1 row)

If roles(users) are not explicitly assigned to a resource queue, they will go to the default resource queue.

sachi=# select * from pg_catalog.pg_resqueue_attributes where rsqname='pg_default';

rsqname | resname | ressetting | restypid

------------+-------------------+------------+----------

pg_default | active_statements | 20 | 1

pg_default | max_cost | -1 | 2

pg_default | min_cost | 0 | 3

pg_default | cost_overcommit | 0 | 4

pg_default | priority | medium | 5

pg_default | memory_limit | -1 | 6

(6 rows)

sachi=#

All users must be assigned to a resource queue. If not explicitly assigned to a particular queue, users will go into the default resource queue, pg_default. If you wish to remove a role from a resource queue and put them in the default queue, change the role’s queue assignment to none. For example:

sachi=# ALTER ROLE sachi RESOURCE QUEUE none;

Resource scheduling is enabled by default when you install Greenplum Database. All database roles must be assigned to a resource queue. If an administrator creates a role without explicitly assigning it to a resource queue, the role is assigned to the default resource queue, pg_default.