v.25.5Improvement
Add an ability to apply lightweight deletes
Added an ability to apply lightweight deletes on the fly (with settingslightweight_deletes_sync = 0,apply_mutations_on_fly = 1. #79281 (Anton Popov).
Why it matters
This feature allows users to perform lightweight deletions without waiting for synchronous mutation commits, enabling more efficient and immediate data deletion within ClickHouse. It improves performance by avoiding synchronous overhead and allows mutations to be applied dynamically during query execution.How to use it
To enable this feature, set the settings as follows:SET lightweight_deletes_sync = 0;
SET apply_mutations_on_fly = 1;This configuration allows lightweight deletes to be applied on the fly during query processing.