v.23.9Improvement

Enable allow_remove_stale_moving_parts by default

Enable allow_remove_stale_moving_parts by default. #54260 (vdimir).
Enable the allow_remove_stale_moving_parts setting by default in ClickHouse.

Why it matters

This feature ensures that stale moving parts from data parts are removed automatically without requiring manual configuration. It improves system hygiene and maintains data consistency by preventing accumulation of obsolete temporary data.

How to use it

The setting allow_remove_stale_moving_parts is now enabled by default, so no additional user action is required. To disable this behavior, explicitly set allow_remove_stale_moving_parts = 0 in the server or session configuration.