These controls begin with connection management—the ability to multiplex thousands of connected users while minimizing connection resources and load on the system. Next are user-based resource queues, which perform “admission control” and manage the flow of queries into the system based on administrator policies. Finally, Greenplum’s Dynamic Query Prioritization technology gives administrators full control of runtime query prioritization and ensures that all queries get their appropriate share of system resources. Together these controls provide administrators with the simple, flexible, and powerful controls they need to meet workload SLAs in complex, mixed-workload environments
