> ## Documentation Index
> Fetch the complete documentation index at: https://clickhouse.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# uncompressed_cache_* server settings

> ClickHouse server settings in the uncompressed_cache_* generated group.

export const SettingsInfoBlock = ({type, default_value, changeable_without_restart}) => {
  return <div className="not-prose" style={{
    display: "flex",
    flexWrap: "wrap",
    alignItems: "baseline",
    columnGap: "0.5rem",
    rowGap: "0.125rem",
    margin: "0.375rem 0",
    fontSize: "0.8125rem",
    lineHeight: "1.125rem"
  }}>
      <div style={{
    fontWeight: 600,
    opacity: 0.72
  }}>Type</div>
      <div style={{
    overflowWrap: "anywhere"
  }}>{type}</div>
      <div style={{
    fontWeight: 600,
    opacity: 0.72,
    marginInlineStart: "0.5rem"
  }}>Default</div>
      <div style={{
    overflowWrap: "anywhere"
  }}>{default_value}</div>
      {changeable_without_restart && <div style={{
    fontWeight: 600,
    opacity: 0.72,
    marginInlineStart: "0.5rem"
  }}>
          Changeable without restart
        </div>}
      {changeable_without_restart && <div style={{
    overflowWrap: "anywhere"
  }}>
          {changeable_without_restart}
        </div>}
    </div>;
};

These settings configure the ClickHouse server and are autogenerated from ClickHouse source.

<h2 id="uncompressed_cache_policy">
  uncompressed\_cache\_policy
</h2>

<SettingsInfoBlock type="String" default_value="SLRU" changeable_without_restart="No" />Uncompressed cache policy name.

<h2 id="uncompressed_cache_size">
  uncompressed\_cache\_size
</h2>

<SettingsInfoBlock type="UInt64" default_value="0" changeable_without_restart="Yes" />

Maximum size (in bytes) for uncompressed data used by table engines from the MergeTree family.

There is one shared cache for the server. Memory is allocated on demand. The cache is used if the option `use_uncompressed_cache` is enabled.

The uncompressed cache is advantageous for very short queries in individual cases.

<Note>
  A value of `0` means disabled.

  This setting can be modified at runtime and will take effect immediately.
</Note>

<h2 id="uncompressed_cache_size_ratio">
  uncompressed\_cache\_size\_ratio
</h2>

<SettingsInfoBlock type="Double" default_value="0.5" changeable_without_restart="No" />The size of the protected queue (in case of SLRU policy) in the uncompressed cache relative to the cache's total size.
