8000 Improve patternsel() by applying the operator itself to each value · postgrespro/postgres_cluster@ce8fd39 · GitHub
[go: up one dir, main page]
Skip to content

Commit ce8fd39

Browse files
tglsfdctglsfdc
committed
Improve patternsel() by applying the operator itself to each value
listed in the column's most-common-values statistics entry. This gives us an exact selectivity result for the portion of the column population represented by the MCV list, which can be a big leg up in accuracy if that's a large fraction of the population. The heuristics involving pattern contents and prefix are applied only to the part of the population not included in the MCV list.
1 parent ad24b8e commit ce8fd39

File tree

1 file changed

+180
-92
lines changed

1 file changed

+180
-92
lines changed

0 commit comments

Comments
 (0)
0