-
Type:
Task
-
Resolution: Unresolved
-
Priority:
Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
None
-
Storage Execution
-
None
-
None
-
None
-
None
-
None
-
None
-
None
Across SPM-4215 and SPM-4469 we introduced a number of knobs:
- setParameter primaryDrivenIndexBuildIndexInsertionBatchSize
- setParameter primaryDrivenIndexBuildIndexInsertionBatchBytes
- setParameter primaryDrivenIndexBuildSorterInsertionBatchSize
- setParameter primaryDrivenIndexBuildSorterInsertionBatchBytes
- setParameter primaryDrivenIndexBuildPrefetching
- indexBuildSpillingMinAvailableDiskSpaceBytes
- primaryDrivenIndexBuildScanPhaseContainerWriteMBperSec
- primaryDrivenIndexBuildBulkLoadPhaseContainerWriteMBperSec
We should introduce some guidance over what these control/when it might be beneficial to set these to higher or lower values. At a minimum, it seems to me that the last two parameters can help throttle writes and lower the impact of primary driven index builds on user workloads.