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. Requiresuse_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. Requiresuse_text_index_like_evaluation_by_dictionary_scan to be enabled.