Details
-
Bug
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Fixed
-
1.5.3
-
None
-
2020-8
Description
The memory configuration settings in Columnstore.xml are not ideal. They should be:
TotalUmMemory 25%
NumBlocksPct 50%
These numbers work well in a combined UM/PM system, which is what is most often used.
We also need to add
lower_case_table_names = 1
to columnstore.cnf