These settings are available in system.settings and are autogenerated from source.
text_index_hint_max_selectivity
Maximal selectivity of the filter to use the hint built from the inverted text index.
text_index_lazy_intersection_density_threshold
Aliases: text_index_density_threshold
Posting list density threshold that selects the intersection algorithm in lazy posting list apply mode (text_index_posting_list_apply_mode = 'lazy').
Below the threshold: leapfrog intersection (favors sparse posting lists). At or above: brute-force bitmap intersection (favors dense posting lists).
text_index_like_max_postings_to_read
Maximum number of large postings to read when text index LIKE evaluation by the dictionary scan is enabled.
Requires use_text_index_like_evaluation_by_dictionary_scan to be enabled.
text_index_like_min_pattern_length
Minimum length of the alphanumeric needle in a LIKE/ILIKE pattern required to use the text index LIKE evaluation by the dictionary scan.
Patterns shorter than this threshold match too many dictionary tokens and are skipped to avoid expensive scans.
Requires use_text_index_like_evaluation_by_dictionary_scan to be enabled.
text_index_posting_list_apply_mode
Controls how posting lists are applied during text index queries.
‘materialize’ eagerly decodes posting lists into Roaring Bitmaps.
‘lazy’ (default) uses cursor-based on-demand decoding (requires an index format with a serialized codec).
‘lazy’ is applied only where it is supported: queries with patterns (such as LIKE) and parts with an index written by an older version fall back to ‘materialize’. Last modified on August 7, 2026
