Create a type-specific typanalyze routine for tsvector, which collects stats
Tom Lane <tgl@sss.pgh.pa.us>
Create a type-specific typanalyze routine for tsvector, which collects stats on the most common individual lexemes in place of the mostly-useless default behavior of counting duplicate tsvectors. Future work: create selectivity estimation functions that actually do something with these stats. (Some other things we ought to look at doing: using the Lossy Counting algorithm in compute_minimal_stats, and using the element-counting idea for stats on regular arrays.) Jan Urbanski
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/catalogs.sgml | modified | +5 −3 |
| src/backend/catalog/system_views.sql | modified | +25 −25 |
| src/backend/tsearch/Makefile | modified | +2 −2 |
| src/backend/tsearch/ts_typanalyze.c | added | +403 −0 |
| src/include/catalog/catversion.h | modified | +2 −2 |
| src/include/catalog/pg_operator.h | modified | +2 −1 |
| src/include/catalog/pg_proc.h | modified | +4 −1 |
| src/include/catalog/pg_statistic.h | modified | +16 −1 |
| src/include/catalog/pg_type.h | modified | +2 −2 |
| src/include/tsearch/ts_type.h | modified | +3 −1 |
| src/test/regress/expected/rules.out | modified | +3 −3 |