Vertica Analytics Platform Version 9.3.x Documentation

Configuring Resource Pools in Management Console

Database administrators can view information about resource pool parameters and make changes to existing parameters in MC through the Resource Pools Configuration page. You can also create and remove new resource pools, assign resource pool users, and assign cascading pools.

Access the Resource Pools Configuration page from the Settings page by selecting the Resource Pools tab.

You can also access the Configuration page from the Resource Pools Monitoring chart, accessible through the Management Console Activity page. Click the tools icon on the top of the leftmost sidebar.

Permissions for Monitoring and Configuring Resource Pools

Only the database administrator can monitor and configure resource pools in Management Console.

Modify Resource Pool Parameters

  1. On the Resource Pools Configuration page, choose a resource pool from the Resource Pools field. Parameter fields for that resource pool appear.
  2. Use the parameter fields to view and modify parameters for the resource pool. Hover your cursor in the parameter field to display information about that parameter.
  3. Click Apply to save your changes. A success message appears

Modify Resource Pool Users

To add or remove resource pool users:

  1. On the Resource Pools Configuration page, select a resource pool from the Resource Pools field.
  2. Next to the Pool Users field, click Add/Remove Pool Users. The Modify Users for Resource Pool dialog appears.


  3. The dialog displays users assigned to the resource pool in the Current Pool Users list. The Other Users list displays all other resource pool users are displayed, along with the pool to which they are currently assigned.
    1. To add users to the resource pool: Select the desired users from Other Users list and click Add.
    2. To remove users from the resource pool: Select the users to be removed from the Current Pool Users list and click Remove.
  4. Click Apply to save your changes. A success message appears.

Create and Remove Resource Pools

Database administrators can use MC to create resource pools and assign resource pool users, and remove user-generated resource pools.

To create a resource pool:

  1. On the Resource Pools Configuration page, click Create Pool. Fields pre-populated with pool parameter default values appear.
  2. Enter the new resource pool's parameters in the fields.
  3. Click Create Pool. A success message appears.

To remove a resource pool:

  1. First, remove all users from the resource pool to be deleted. This can be done on the Resource Pool Configuration Page.
  2. When all users have been removed from the resource pool, choose the resource pool from the Resource Pools field on the Resource Pool Configuration Page. Parameter fields for that resource pool appear.
  3. Click Remove Pool. A Confirm dialog appears.
  4. Click OK in the Confirm dialog. A success message appears.

See Also