Full Text Search: Limitations

12.11. Limitations

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

• The length of each lexeme must be less than 2K bytes

• 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

• No more than 256 positions per lexeme

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

For comparison, the PostgreSQL 8.1 documentation contained 10,441 unique words, a total of 335,420 words, and the most frequent word 登录查看完整内容