Re: [GENERAL] how many JOINs?

2004-11-27 Thread Uwe C. Schroeder
-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 lim

Re: [GENERAL] how many JOINs?

2004-11-27 Thread Tom Lane
Konstantin Danilov <[EMAIL PROTECTED]> 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?

[GENERAL] how many JOINs?

2004-11-27 Thread Konstantin Danilov
Hello List! Do you know how many times can JOIN be used in a query? How many JOINs does PostgreSQL support in ONE query? ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to