Julius,
> I have a question concerning performance. One of my queries take a long
> to execute. I tried to do "explain analyse" and I see that the
> sequential scan is being used, although I have indexes set on columns
> that are used in joins. The question is - WHY, and how to change that
> behavior???
This is not the right mailing list for your question. Please send it to
pgsql-performance mailing list instead.
--
Josh Berkus
PostgreSQL @ Sun
San Francisco