Re: Join Scalability

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Darryl Pye <darrylpye(at)hotmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Join Scalability
Date: 2010-07-12 15:44:10
Message-ID: 16233.1278949450@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Darryl Pye <darrylpye(at)hotmail(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Bruce Momjian 2010-07-12 15:44:34 Re: how to change line terminator
Previous Message Matthew Sleight 2010-07-12 11:31:21