Jonathan Marks <jonathanaverymarks(at)gmail(dot)com> writes:
> ... we run into the max tsvector length requirement "The length of a tsvector (lexemes + positions) must be less than 1 megabyte”
> Is there any way to disable or increase that limit in Postgres 10.3?
No; it's forced by the representation used for tsvector, which stores
lexeme offsets in 20-bit fields (cf WordEntry in
src/include/tsearch/ts_type.h). Perhaps that was short-sighted but
I don't foresee it changing anytime soon. You'd more or less need
a whole new datatype ("bigtsvector"?) to make it happen.
regards, tom lane