Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: How many joins is too many joins....
Date
Msg-id 23309.1044586912@sss.pgh.pa.us
Whole thread Raw
In response to How many joins is too many joins....  ("codeWarrior" <GPatnude@adelphia.net>)
Responses Re: How many joins is too many joins....  (Francisco J Reyes <fran@natserv.net>)
List pgsql-general
Tree view 
"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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: AllocSetAlloc() error message
Next
From: Tom Lane
Date:
Subject: Re: plpgsql - fetching from returned cursors