Hello, I would need more info about index types in postgre (btree, hash, gin and gist) - is there any guide that explains in detail when to use which index type? These index types have different performance with certain collumn types and data characteristics store in them. There's not much info about it pg docs. So, does any document describing detailed index usage or do you have any personal recomendations when to use which index?
http://people.planetpostgresql.org/mha/index.php?/archives/112-GIN-performance-postgresql.org-websearch-part-2.html http://people.planetpostgresql.org/xzilla/index.php?/archives/278-PostgreSQL-full-text-search-testing.html Summary: * fulltext, GIS, arrays .. gin, gist indexes (gin is faster, but slow update) * others .. btree index (I don't know anybody who use hash index) Regards Pavel Stehule ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
