PostgreSQL: GIN or GiST indexes?
First of all, do you need to use them for text search indexing? GIN and GiST are index specialized for some data types. If you need to index simple char or integer values then the normal B-Tree index is the best. Anyway, PostgreSQL documentation has a chapter on GIST and one on GIN, where you … Read more