Fix tsmatchsel() to account properly for null rows.

Tom Lane <tgl@sss.pgh.pa.us>

Commit: 52b60530f257b1591d8b72264cd6c0dd9aabfd46
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2011-02-18T00:00:49Z
Releases: 9.1.0
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

Files

PathChange+/−
src/backend/tsearch/ts_selfuncs.c modified +6 −0
src/include/catalog/pg_statistic.h modified +2 −0