| 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: | Whole Thread | Raw Message | 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 |