]> granicus.if.org Git - postgresql/commit
Change patternsel() so that instead of switching from a pure
authorTom Lane <tgl@sss.pgh.pa.us>
Sun, 9 Mar 2008 00:32:09 +0000 (00:32 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Sun, 9 Mar 2008 00:32:09 +0000 (00:32 +0000)
commitf4230d29377556a350866f17ebb2e16ac907fa50
tree76d1422c8b029f26994b5c60ac6ac76587efe08a
parent422495d0da79d8a36d6f3700a96c6acddd3e1d50
Change patternsel() so that instead of switching from a pure
pattern-examination heuristic method to purely histogram-driven selectivity at
histogram size 100, we compute both estimates and use a weighted average.
The weight put on the heuristic estimate decreases linearly with histogram
size, dropping to zero for 100 or more histogram entries.
Likewise in ltreeparentsel().  After a patch by Greg Stark, though I
reorganized the logic a bit to give the caller of histogram_selectivity()
more control.
contrib/ltree/ltree_op.c
src/backend/utils/adt/selfuncs.c
src/include/utils/selfuncs.h