Skip to content
ClickHouse Docs
ClickHouse DocsClickHouse Docs

use_text_* session settings

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

use_text_index_header_cache

Type
Bool
Default
1
Version history
VersionDefault valueComment
26.71Enabled the text index header cache globally.
25.110New setting

Whether to cache deserialized text index headers in memory. Using the text index header cache can significantly reduce latency and increase throughput when working with a large number of text index queries.

use_text_index_like_evaluation_by_dictionary_scan

Type
Bool
Default
1
Version history
VersionDefault valueComment
26.41New setting

Enable evaluation of LIKE/ILIKE queries by scanning the inverted text index dictionary.

use_text_index_negative_tokens_cache

Type
Bool
Default
1
Version history
VersionDefault valueComment
26.81New setting to cache absent text index tokens and avoid repeated dictionary lookups.

Whether to cache text index tokens that are absent from a data part. The negative tokens cache uses the text index tokens cache and avoids repeated dictionary lookups for absent tokens.

use_text_index_postings_cache

Type
Bool
Default
0
Version history
VersionDefault valueComment
25.110New setting

Whether to cache deserialized text index deserialized posting lists in memory. Using the text index postings cache can significantly reduce latency and increase throughput when working with a large number of text index queries.

use_text_index_tokens_cache

Type
Bool
Default
1
Version history
VersionDefault valueComment
26.71Enabled the text index tokens cache globally.
26.30New setting

Whether to cache deserialized text index token infos in memory. Using the text index tokens cache can significantly reduce latency and increase throughput when working with a large number of text index queries.

Navigation