Skip to content
ClickHouse Docs
ClickHouse DocsClickHouse Docs
49.6kGet Started

temporary_files_* session settings

View as MarkdownEdit this pageReport an issueSet up docs MCP

These settings are available in system.settings and are autogenerated from source.

temporary_files_buffer_size

Type
NonZeroUInt64
Default
1048576
Version history
VersionDefault valueComment
25.101048576New setting

Size of the buffer for temporary files writers. Larger buffer size means less system calls, but more memory consumption. A value above 1 GiB is reduced to 1 GiB.

temporary_files_codec

Type
String
Default
LZ4

Sets compression codec for temporary files used in sorting and joining operations on disk.

Possible values:

  • LZ4 — LZ4 compression is applied.
  • NONE — No compression is applied.
Navigation