| 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 |
| Thread: | |
| 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-----
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Woodchuck Bill | 2004-11-27 18:37:47 | Re: comp.databases.postgresql.* groups and RFD |
| Previous Message | Tom Lane | 2004-11-27 18:27:43 | Re: Boolean error |