From: | Fred Miller <fred(at)frederickmiller(dot)com> |
---|---|
To: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Max tables in a union |
Date: | 2010-10-30 13:18:52 |
Message-ID: | 2EF544E5-D47B-4743-AE7B-EA2C424E89BB@frederickmiller.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 <fred(dot)miller(at)me(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Geoghegan | 2010-10-30 13:45:58 | Re: Unhandled exception in PGAdmin when opening 16-million-record table |
Previous Message | Mike Christensen | 2010-10-30 11:21:28 | Re: pgAdmin on Mac connecting to Postgres 9 on Linux - SSL/timeout issue |