Re: how many JOINs ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Konstantin Danilov <danilov_konst(at)list(dot)ru>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: how many JOINs ?
Date: 2004-11-27 18:14:55
Message-ID: 26956.1101579295@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Konstantin Danilov <danilov_konst(at)list(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-11-27 18:21:09 Re: Could we hide the table name listing from unprivileged user?
Previous Message Tom Lane 2004-11-27 17:58:36 Re: row-level deadlock problem