v.24.4Improvement
Added lightweight_deletes_sync setting for synchronous lightweight delete behavior
Added settinglightweight_deletes_sync(default value: 2 - wait all replicas synchronously). It is similar to settingmutations_syncbut affects only behaviour of lightweight deletes. #62195 (Anton Popov).
Why it matters
This feature addresses the need to manage how lightweight delete mutations are propagated and confirmed across replicas. By enabling configurable synchronous waiting, it ensures consistency and control over the delete operation timing, improving reliability and user expectations in replicated environments.How to use it
Users can set thelightweight_deletes_sync setting to control synchronization behavior of lightweight deletes. The default value is 2, which waits for all replicas to apply the delete synchronously. Adjust the setting value according to desired replication sync guarantees, for example:SET lightweight_deletes_sync = 2Apply this setting at the session or query level to enforce synchronization for lightweight delete mutations only.