Any "guide to indexes" exists? - Mailing list pgsql-general

From Jan Bilek
Subject Any "guide to indexes" exists?
Date
Msg-id 003d01c790b1$5b05b3e0$0100a8c0@ook
Whole thread Raw
Responses Re: Any "guide to indexes" exists?
Re: Any "guide to indexes" exists?
List pgsql-general
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?

Thanks for you answers.

Regards,
Jan


pgsql-general by date:

Previous
From: Jaime Silvela
Date:
Subject: linux bug and lost rows
Next
From: Tom Lane
Date:
Subject: Re: shmget fails on OS X with proper settings