]> granicus.if.org Git - postgresql/commit
Fix tsmatchsel() to account properly for null rows.
authorTom Lane <tgl@sss.pgh.pa.us>
Fri, 18 Feb 2011 00:01:01 +0000 (19:01 -0500)
committerTom Lane <tgl@sss.pgh.pa.us>
Fri, 18 Feb 2011 00:01:01 +0000 (19:01 -0500)
commit2b3a0630b54ff9970a7cd2c78a686015f9a53c0c
tree5dfcc711292be33f0a8097cfa848f5c86ef22131
parent42e663cc4139bba218efccfb53293cd6e6fa43da
Fix tsmatchsel() to account properly for null rows.

ts_typanalyze.c computes MCE statistics as fractions of the non-null rows,
which seems fairly reasonable, and anyway changing it in released versions
wouldn't be a good idea.  But then ts_selfuncs.c has to account for that.
Failure to do so results in overestimates in columns with a significant
fraction of null documents.  Back-patch to 8.4 where this stuff was
introduced.

Jesper Krogh
src/backend/tsearch/ts_selfuncs.c
src/include/catalog/pg_statistic.h