Archibald Zimonyi <archie(at)netg(dot)se> writes:
> On demand, I'll post the database structure as well as the SQL query which
> creates the slow respons. I'll add them as attachments (do they come at
> all?).
You're forcing the join order by using explicit JOIN syntax.
Rearranging the join order might yield a better plan. See
http://www.postgresql.org/users-lounge/docs/7.1/postgres/explicit-joins.html
regards, tom lane