OSDN Git Service

Improve patternsel() by applying the operator itself to each value
authorTom Lane <tgl@sss.pgh.pa.us>
Tue, 10 Jan 2006 17:35:52 +0000 (17:35 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Tue, 10 Jan 2006 17:35:52 +0000 (17:35 +0000)
commitce8fd39e15894da00e1e209c47eb0936265227c5
tree42c3a6caebbf29733bcb36b59c3e5a7c43007ffb
parentad24b8e6eef1f860c888ecfd2440c4761e3a9910
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.
src/backend/utils/adt/selfuncs.c