This topic lists limitations and maximums for Greenplum Database full text search objects.
The current limitations of Greenplum Database’s text search features are:
tsquerytypes are not supported in the distribution key for a Greenplum Database table
tsvector(lexemes + positions) must be less than 1 megabyte
tsvectormust be greater than 0 and no more than 16,383
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.
Parent topic: Using Full Text Search