system.storage_policies

    • (String) — Name of the storage policy.
    • () — Volume order number in the configuration.
    • (UInt64) — Maximum size of a data part that can be stored on volume disks (0 — no limit).
    • () — Value of the prefer_not_to_merge setting. When this setting is enabled, merging data on this volume is not allowed. This allows controlling how ClickHouse works with slow disks.