Postgres Pro
Downloads
Home   >   mailing lists

Re: Max Tables in a union - Mailing list pgsql-general

From Tom Lane
Subject Re: Max Tables in a union
Date
Msg-id 10022.1288389656@sss.pgh.pa.us
Whole thread Raw
In response to Max Tables in a union  (Fred Miller <fred@frederickmiller.com>)
List pgsql-general
Tree view 
Fred Miller <fred@frederickmiller.com> writes:
> What is the max number of tables allowed in a union (in 8.4 and 9.0)?

There's no specific limit.  I doubt you'd get good performance with
thousands ...

            regards, tom lane

pgsql-general by date:

Previous
From: Andy Colson
Date:
Subject: Re: Can Postgres Not Do This Safely ?!?
Next
From: Mike Christensen
Date:
Subject: pgAdmin on Mac connecting to Postgres 9 on Linux - SSL/timeout issue