9 - HP Vertica Database Intro Series

Vertica Database Resource Management HP Vertica provides a sophisticated resource management scheme that allows many concurrent workloads to be performed efficiently in the database.   For basic operations, and used the GENERAL pool that is pre-configured based on RAM (memory) and CPU's, but you can create and customize new pools to handle the specific requirements.   You can also define new sets of resources that you configure to limit the use of memory, competition and query priority. You can then optionally restrict each database user to use a pool of specific features that control memory resources used by their applications.    User-defined pools are useful if you have competing for resources in different classes of workloads. Examples of situations: A batch job takes up all server resources, leaving small web queries that update to wait for resources, which can degrade the user experience:   In this scenario, you can create a pool of resources to deal with web page requests and ensure that users get the resources they need. Another option is to create a pool of limited resources to the batch job, so the work does not use all the system resources. Sometimes an application has a lower priority than other applications, and you want to limit the amount of memory and number of concurrent users to the application of low priority:    In this scenario, you can create a resource pool, with a maximum limit to the query memory and associate the resource pool with the users of low-priority application.