"Preferred Index Types for Text Search" https://www.postgresql.org/docs/current/textsearch-indexes.html https://www.postgresql.org/docs/current/textsearch-index

"Preferred Index Types for Text Search" https://www.postgresql.org/docs/current/textsearch-indexes.html https://www.postgresql.org/docs/current/textsearch-indexes.h... : > There are two kinds of indexes that can be used to speed up full text searches: GIN and GiST. Note that indexes are not mandatory for full text searching, but in cases where a column is searched on a regular basis, an index is usually desirable.