Re: [GENERAL] Max tables in a union
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: > On Fri, Oct 29, 2010 at 3:11 PM, Fred Miller 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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Max tables in a union
On Fri, Oct 29, 2010 at 3:11 PM, Fred Miller 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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Max tables in a union
What is the maximum number of tables allowed in a union in 8.4 and 9.0? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Max Tables in a union
Fred Miller 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Max Tables in a union
What is the max number of tables allowed in a union (in 8.4 and 9.0)? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general