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. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match