Fix tsmatchsel() to account properly for null rows.
Tom Lane <tgl@sss.pgh.pa.us>
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
| Path | Change | +/− |
|---|---|---|
| src/backend/tsearch/ts_selfuncs.c | modified | +6 −0 |
| src/include/catalog/pg_statistic.h | modified | +2 −0 |