How many joins is too many joins....
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...
"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
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.