Re: Max tables in a union

Поиск
Список
Период
Сортировка
От Fred Miller
Тема Re: Max tables in a union
Дата
Msg-id 2EF544E5-D47B-4743-AE7B-EA2C424E89BB@frederickmiller.com
обсуждение исходный текст
Ответ на Re: Max tables in a union  (Scott Marlowe <scott.marlowe@gmail.com>)
Список 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
seeTom Lane's reply. 

We have some dynamic-schema generation action happening here and are using unions for at least the time-being.
Potentialperf 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.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.


В списке pgsql-general по дате отправления:

Предыдущее
От: Mike Christensen
Дата:
Сообщение: Re: pgAdmin on Mac connecting to Postgres 9 on Linux - SSL/timeout issue
Следующее
От: Peter Geoghegan
Дата:
Сообщение: Re: Unhandled exception in PGAdmin when opening 16-million-record table