Обсуждение: pgsql: Improve patternsel() by applying the operator itself to each

Поиск
Список
Период
Сортировка

pgsql: Improve patternsel() by applying the operator itself to each

От
tgl@postgresql.org (Tom Lane)
Дата:
Log Message:
-----------
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.

Modified Files:
--------------
    pgsql/src/backend/utils/adt:
        selfuncs.c (r1.194 -> r1.195)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/selfuncs.c.diff?r1=1.194&r2=1.195)