Max tables in a union

On Fri, Oct 29, 2010 at 3:11 PM, Fred Miller <fred.miller@me.com> wrote:

What is the maximum number of tables allowed in a union in 8.4 and 9.0?

I'm not aware of any preset limit. I'd guess you'd run into
performance problems before you hit a limit.
--
To understand recursion, one must first understand recursion.

Thanks all -- I made my first post under an unregistered account. It was stalled. Then I posted under my registered account - to which Tom Lane replied (thanks Tom) Then later my first post punched through making it seem like I didn't see Tom Lane's reply.

We have some dynamic-schema generation action happening here and are using unions for at least the time-being. Potential perf issues aside, we just wanted to be aware of the limits if there were any.

Thanks again.

On Oct 30, 2010, at 3:22 AM, Scott Marlowe wrote: