Hilmar Lapp <hlapp@gmx.net> writes:
> I have a query generated by an application (not mine, but there's
> nothing I can find that looks bad about the query itself) that takes an
> excessive amount of time to return even though there are almost no rows
> in the schema yet.
Read
http://www.ca.postgresql.org/users-lounge/docs/7.3/postgres/explicit-joins.html
regards, tom lane