Can I execute range merge?

I inserted data. That table’s range consist of 9 ranges.
And I deleted everything on that table.
but it remained 9 ranges after 25 hours(gc.ttlseconds) executed delete.

I wonder when started the range merge?
Can I start range merge some table?

Hey @yeri,

Let’s confirm that range merging is set to be enabled. Can you go ahead and confirm that the cluster setting kv.range_merge.queue_enabled is set to true?

Cheers,
Ricardo

Hi.
Of course. Already I checked.
kv.range_merge.queue_enabled = true.

Hi.
Of course. Already I checked.
kv.range_merge.queue_enabled = true.

Can I execute range merge? do you have command?
and
When I checked again about 50 hours after the deletion, the range was reduced to 1.
When start the range merge?

Hello @yeri

The delay in the ranges being merge could be due to a few different factors. The most likely reason is due to the range_min_bytes and range_max_bytes zone configuration settings, as they are described here. These thresholds have to be reached for either the ranges to be split, or the ranges to be merged, in conjunction with the gc.ttlseconds zone configuration setting. So if the range is still above that range_min_bytes threshold, then the range will stay as is.

As far as I know, there is no SQL query or CLI command that can be run to initiate a range merge. Depending on the above zone configurations, the ranges would merge almost as soon as those thresholds are met. Let me know if there are any other questions.

Cheers,
Ricardo