"Jan Bilek" <bilekj@xxxxxxxxx> 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 dealing with, ie, the WHERE clauses are not simple scalar equality or range checks. All you need to pay attention to is whether the index has an operator class that includes the WHERE operator you want to use. regards, tom lane
