| Lists: | pgsql-general |
|---|
| From: | Konstantin Danilov <danilov_konst(at)list(dot)ru> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | how many JOINs ? |
| Date: | 2004-11-27 10:59:07 |
| Message-ID: | E1CY0IF-000BLf-00.danilov_konst-list-ru@f13.mail.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
Hello List!
Do you know how many times can JOIN be used in a query? How many JOINs does PostgreSQL support in ONE query?
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Konstantin Danilov <danilov_konst(at)list(dot)ru> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: how many JOINs ? |
| Date: | 2004-11-27 18:14:55 |
| Message-ID: | 26956.1101579295@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
Konstantin Danilov <danilov_konst(at)list(dot)ru> writes:
> Do you know how many times can JOIN be used in a query? How many JOINs does PostgreSQL support in ONE query?
The theoretical upper limit would be around 21000, I think, due to
rangetable indexes being 16 bits. Did you need more?
regards, tom lane
| From: | "Uwe C(dot) Schroeder" <uwe(at)oss4u(dot)com> |
|---|---|
| To: | Konstantin Danilov <danilov_konst(at)list(dot)ru>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: how many JOINs? |
| Date: | 2004-11-27 18:28:21 |
| Message-ID: | 200411271028.22081.uwe@oss4u.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Saturday 27 November 2004 02:59 am, Konstantin Danilov wrote:
> Hello List!
> Do you know how many times can JOIN be used in a query? How many JOINs does
> PostgreSQL support in ONE query?
>
I think you will run out of memory before hitting the limit on the number of
joins.
UC
- --
Open Source Solutions 4U, LLC 2570 Fleetwood Drive
Phone: +1 650 872 2425 San Bruno, CA 94066
Cell: +1 650 302 2405 United States
Fax: +1 650 872 2417
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)
iD8DBQFBqMdGjqGXBvRToM4RAswbAJ98WLPEtnWwXmEpGWiejhmHf4sTDgCaA6p3
v3H98PZeyap0r8vS9ox2GbQ=
=x+Qd
-----END PGP SIGNATURE-----