As a distributed MPP database, ClustrixDB Xpand is able to leverage multiple nodes and cores to process queries faster than single-node databases. Two tunable processes are available that facilitate this.
Clustrix Xpand has chosen a set of default parameters to control those processes that serve most common workloads. Depending on your specific workload, cluster specifications, and the latency requirements of your application, you may want to tune some of these variables.
The ClustrixDB Xpand Fair Scheduler ensures that long-running queries do not monopolize CPU resources. It does this by prioritizing queries that return fewer rows ahead of queries that return a larger number of rows. This helps balance workloads across nodes and is particularly useful for clusters that mix long-running Online Analytical Processing (OLAP) and shorter-running Online Transaction Processing (OLTP).