On May 7, 2007, at 11:01 AM, Karsten Hilbert wrote:
On Mon, May 07, 2007 at 10:47:24AM -0500, Jim Nasby wrote:
GiST can also be useful if you have to query in multiple dimensions,
which can occur outside the normal case of geometry. Best example I
know of is a table containing duration
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
Am Montag, 7. Mai 2007 16:09 schrieb Jan Bilek:
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?
You use btree unless you have a specific, particular reason to use one of the
other ones.
I was asking for these specific/particular reasons. Im not the database
developer, to be expert on indexes (i know whats btree and hash - gin and
gist are rather mysterious for me).
Ok - btree is fine, but sometimes could be better to use gist - my question
is: when is that sometimes? Unless i
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
On May 7, 2007, at 9:44 AM, Pavel Stehule wrote:
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
On Mon, May 07, 2007 at 10:47:24AM -0500, Jim Nasby wrote:
GiST can also be useful if you have to query in multiple dimensions,
which can occur outside the normal case of geometry. Best example I
know of is a table containing duration information in the form of
start_time and end_time.
Jan Bilek [EMAIL PROTECTED] writes:
Ok - btree is fine, but sometimes could be better to use gist - my question
is: when is that sometimes? Unless i know how to use the indexes, then
they are useless for me - am i right?
gist and gin are for indexing queries that btree is not capable of
[EMAIL PROTECTED] (Jan Bilek) writes:
I was asking for these specific/particular reasons. Im not the
database developer, to be expert on indexes (i know whats btree and
hash - gin and gist are rather mysterious for me).
Ok - btree is fine, but sometimes could be better to use gist - my