| From: | Francisco J Reyes <fran(at)natserv(dot)net> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | codeWarrior <gpatnude(at)hotmail(dot)com>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: How many joins is too many joins.... |
| Date: | 2003-02-10 02:44:43 |
| Message-ID: | 20030209214332.L40450-100000@zoraida.natserv.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, 6 Feb 2003, Tom Lane wrote:
> "codeWarrior" <GPatnude(at)adelphia(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Mitchell | 2003-02-10 02:50:21 | Re: PostgreSQL x Oracle |
| Previous Message | Francisco J Reyes | 2003-02-10 02:43:08 | Re: FreeBSD: SMP and PostgreSQL |