Обсуждение: how many JOINs?

Hello List!
Do you know how many times can JOIN be used in a query? How many JOINs does PostgreSQL support in ONE query?

Konstantin Danilov <danilov_konst@list.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

-----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-----