how many JOINs?

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