Re: how many JOINs? - Mailing list pgsql-general

From Uwe C. Schroeder
Subject Re: how many JOINs?
Date
Msg-id 200411271028.22081.uwe@oss4u.com
Whole thread Raw
In response to how many JOINs?  (Konstantin Danilov <danilov_konst@list.ru>)
List 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-----


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Boolean error
Next
From: Eric E
Date:
Subject: ODBC driver troubles