v.23.8Improvement

Added Server Setting to Limit Array Size for groupArray Function

Added server setting aggregate_function_group_array_max_element_size. This setting is used to limit array size for groupArray function at serialization. The default value is 16777215. #53550 (Nikolai Kochetov).
Introduced a new server setting aggregate_function_group_array_max_element_size to limit the size of arrays produced by the groupArray aggregate function during serialization.

Why it matters

This setting addresses the issue of excessively large arrays generated by groupArray by imposing a size limit during serialization, helping to manage memory usage and avoid potential performance degradation or failures caused by overly large array outputs.

How to use it

Set the server parameter aggregate_function_group_array_max_element_size to the desired maximum size value (in bytes) to control the maximum allowed size for groupArray results. The default value is 16777215. You can configure this setting in the server's configuration file or dynamically at runtime if supported.