]> granicus.if.org Git - postgresql/commit
Tweak choose_bitmap_and() heuristics in the light of example provided in bug
authorTom Lane <tgl@sss.pgh.pa.us>
Wed, 30 Nov 2005 17:10:25 +0000 (17:10 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Wed, 30 Nov 2005 17:10:25 +0000 (17:10 +0000)
commit2883fbb80805263dc3e2299d49583a42a6c9e9c0
tree23df259db844756f5fe835c6d733c08708cac23e
parentdd13bf167b24fc497a7ce7f1897a89ae3ac40c9f
Tweak choose_bitmap_and() heuristics in the light of example provided in bug
#2075: consider an index redundant if any of its index conditions were already
used, rather than if all of them were.  Also, make the selectivity comparison
a bit fuzzy, so that very small differences in estimated selectivities don't
skew the results.
src/backend/optimizer/path/indxpath.c