Max Tables in a union

Started by Fred Millerover 15 years ago2 messagesgeneral
Jump to latest
#1Fred Miller
fred@frederickmiller.com

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Fred Miller (#1)
Re: Max Tables in a union

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