Re: Join Scalability - Mailing list pgsql-novice

From Tom Lane
Subject Re: Join Scalability
Date
Msg-id 16233.1278949450@sss.pgh.pa.us
Whole thread Raw
In response to Join Scalability  (Darryl Pye <darrylpye@hotmail.com>)
List pgsql-novice
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

pgsql-novice by date:

Previous
From: "Matthew Sleight"
Date:
Subject:
Next
From: Bruce Momjian
Date:
Subject: Re: how to change line terminator