↑↓ select↵ open⌫ change scopeOpen full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Supported versions: Current (18) / 17 / 16 / 15 / 14
Development versions: 19 / 20devel
Unsupported versions: 13 / 12 / 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3
Development snapshot. PostgreSQL 20devel has not been released. Content may change.
12.11. Limitations
Prev UpChapter 12. Full Text SearchHome Next

12.11. Limitations #

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

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

  • No more than 256 positions per lexeme

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

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

  • The length of a tsquery's data (lexemes only) must be less than 1 megabyte

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

For comparison, the PostgreSQL 8.1 documentation contained 10,441 unique words, a total of 335,420 words, and the most frequent word “postgresql” was mentioned 6,127 times in 655 documents.

Another example — the PostgreSQL mailing list archives contained 910,989 unique words with 57,491,343 lexemes in 461,020 messages.

Prev Up Next
12.10. psql Support Home Chapter 13. Concurrency Control

Report a documentation issue

Read the upstream documentation. For corrections, first check the current manual.