PolarDB:Limitations

The current limitations of PolarDB PostgreSQL's text search features are:

• The length of each lexeme must be less than 2 kilobytes

• The length of a tsvector(lexemes + positions) must be less than 1 megabyte

• The number of lexemes must be less than 2⁶⁴

• Position values in tsvector must be greater than 0 and no more than 16,383

• The match distance in a <>(FOLLOWED BY)tsquery operator cannot be more than 16,384

• No more than 256 positions per lexeme

• The number of nodes (lexemes + operators) in a tsquery must be less than 32,768