These settings are available in system.merge_tree_settings and are autogenerated from ClickHouse source.
refresh_parts_interval
Type
Seconds
Default
0
Version history
| Version | Default value | Comment |
|---|---|---|
| 25.4 | 0 | A new setting |
If it is greater than zero - refresh the list of data parts from the underlying filesystem to check if the data was updated under the hood. It can be set only if the table is located on readonly disks (which means that this is a readonly replica, while data is being written by another replica).
refresh_statistics_interval
Type
Seconds
Default
300
Version history
| Version | Default value | Comment |
|---|---|---|
| 26.2 | 300 | Enable statistics cache |
| 25.11 | 0 | New setting |
The interval of refreshing statistics cache in seconds. If it is set to zero, the refreshing will be disabled.