Jesper Krogh <jesper(at)krogh(dot)cc> writes:
> It seems to me that the row estimates on a ts_vector search is a bit on
> the low side for terms that is not in th MCV-list in pg_stats:
tsvector has its own selectivity estimator that's not like plain scalar
equality. Look into src/backend/tsearch/ts_selfuncs.c if you want to
see the rules.
regards, tom lane