Help Center/ GaussDB/ Developer Guide(Centralized_2.x)/ SQL Reference/ Full Text Search/ Limitations
Updated on 2023-10-23 GMT+08:00
View PDF
Share

Limitations

The current limitations of GaussDB's text search features are:

  • The length of each lexeme must be less than 2 KB.
  • The length of a tsvector (lexemes + positions) must be less than 1 megabyte.
  • Position values in tsvector must be greater than 0 and no more than 16383.
  • No more than 256 positions per lexeme. Excessive positions, if any, will be discarded.
  • The number of nodes (lexemes + operators) in a tsquery must be less than 32768.
Parent topic: Full Text Search