Horton

Re: join over 12 tables takes 3 secs to plan

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Hilmar Lapp <hlapp@gmx.net>
Cc: pgsql-performance@postgresql.org
Date: 2003-01-02T20:24:20Z
Lists: pgsql-performance 
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