"Jan Bilek" <bilekj(at)gmail(dot)com> 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