Postgres Pro
Downloads
Home   >   mailing lists

Re: How many joins is too many joins.... - Mailing list pgsql-general

From Francisco J Reyes
Subject Re: How many joins is too many joins....
Date
Msg-id 20030209214332.L40450-100000@zoraida.natserv.net
Whole thread Raw
In response to Re: How many joins is too many joins....  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
On Thu, 6 Feb 2003, Tom Lane wrote:

> "codeWarrior" <GPatnude@adelphia.net> writes:
> > Anyone have a number for how many joined tables postgreSQL can handle in any
> > given query ? I thought I saw the number 64 somewhere in the docs...
>
> There's no hardwired limit.  Whether you'll get a decent plan is another
> question ...
>             regards, tom lane


At which point do you think it would be usefull to start breaking a query?
If for no other reason the complexity of looking at the explain output
gets daunting afer 5 tables are invoved... at least it is for me.

pgsql-general by date:

Previous
From: Francisco J Reyes
Date:
Subject: Re: FreeBSD: SMP and PostgreSQL
Next
From: guyren@mac.com (Guyren G Howe)
Date:
Subject: Just installed using Fink on OS X. Fails all over the place.