We have made major improvements in GIN in the past few releases,
particularly 9.4, but the full text search docs recommending when to use
GIN and GiST indexes have not been updated. This blog post empirically
shows many of the improvements:
http://blog.pgaddict.com/posts/performance-since-postgresql-7-4-to-9-4-fulltext
I would like to apply the attached patch to 9.5 to recommend GIN indexes
for full text search, and remove mention of many old GIN limitations.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ Everyone has their own god. +