Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: how many JOINs?
Date
Msg-id 26956.1101579295@sss.pgh.pa.us
Whole thread Raw
In response to how many JOINs?  (Konstantin Danilov <danilov_konst@list.ru>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: row-level deadlock problem
Next
From: Tom Lane
Date:
Subject: Re: Could we hide the table name listing from unprivileged user?