Darryl Pye <darrylpye@hotmail.com> writes:
> 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,
Don't do it. Rethink your schema design, instead. Why do you think you
need to join so many tables in one query?
regards, tom lane