This article explains how the maxconcurrency setting affects the number of mergeout tasks that Vertica can run in parallel. It also outlines how increasing memory allocation can allow for higher concurrency, improving mergeout performance and system efficiency.
Environment
- Vertica Analytics Platform all
- Mergeout operations
- Configuration parameters:
maxconcurrency,memorysize,maxmemorysize
Situation
A Vertica system is currently configured to allow only two mergeout tasks to run simultaneously. This is due to the maxconcurrency parameter being set to 2, which limits the number of threads available for mergeout operations.
