Hi
Was wondering how/if postgres degrades as the number of tables joined increases.
I am looking at joining lots (from a few up to 100+) tables in a single query,
All tables will be joined on an indexed integer id,
I am not concerned about amount of data just if that too many joins may cause the planner problems or each join has additional
overhead etc
Regards,
Darryl
Find it at CarPoint.com.au
New, Used, Demo, Dealer or Private?