Re: Performance

jeandre@itvs.co.za writes:
> In the documentation I saw something about different index types. In
> Sybase you create an index and that is it. How do you choose what type of
> index to create on a column in Postgres?

There's an optional clause in the CREATE INDEX command --- I think
"USING access_method", but check the man page.

In practice, 99.44% of indexes are the default btree type, so you
usually don't need to think about it.  I'd only use a non-btree index
if I needed to index non-scalar data (arrays, geometric types, etc);
the GIST and RTREE index types are designed for those.

            regards, tom lane