Any "guide to indexes" exists?

From: "Jan Bilek" <bilekj(at)gmail(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Any "guide to indexes" exists?
Date: 2007-05-07 14:09:39
Message-ID: 003d01c790b1$5b05b3e0$0100a8c0@ook
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-05-07 14:11:29 Re: shmget fails on OS X with proper settings
Previous Message Jaime Silvela 2007-05-07 13:59:50 linux bug and lost rows