v.25.8Improvement
New MergeTree setting search_orphaned_parts_drives
New MergeTree setting search_orphaned_parts_drives to limit scope to look for parts e.g. by disks with local metadata. #84710 (Ilya Golshtein).Why it matters
This feature helps optimize the process of finding orphaned parts in MergeTree tables by limiting the search space to designated disks. It improves efficiency and resource usage by avoiding unnecessary scanning of all storage locations.How to use it
To enable this feature, configure thesearch_orphaned_parts_drives setting in the MergeTree table settings and specify the list of drives where the search for orphaned parts should be performed.