Set up docs MCPThese settings are available in system.settings and are autogenerated from source.
max_size_to_preallocate_for_aggregation
Type
UInt64
Default
1000000000000
Version history
| Version | Default value | Comment |
|---|---|---|
| 24.12 | 1000000000000 | Enable optimisation for bigger tables. |
| 22.12 | 100000000 | This optimizes performance |
For how many elements it is allowed to preallocate space in all hash tables in total before aggregatio
max_size_to_preallocate_for_joins
Type
UInt64
Default
1000000000000
Version history
| Version | Default value | Comment |
|---|---|---|
| 24.7 | 100000000 | New setting. |
| 24.12 | 1000000000000 | Enable optimisation for bigger tables. |
For how many elements it is allowed to preallocate space in all hash tables in total before joi