Thread: Max Tables in a union

Max Tables in a union

From

Fred Miller

Date:

29 October 2010, 21:31:02

What is the max number of tables allowed in a union (in 8.4 and 9.0)?

Re: Max Tables in a union

From

Tom Lane

Date:

29 October 2010, 22:01:06

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