What if we just didn’t use positional arguments at all? I.e. we just populate the tsvector with lexemes only?
> On Jun 20, 2018, at 10:49 AM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
>
> Jonathan Marks <jonathanaverymarks@xxxxxxxxx> 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
