Re: Query plan for very large number of joins

Поиск
Список
Период
Сортировка
От PFC
Тема Re: Query plan for very large number of joins
Дата
Msg-id op.srrekazoth1vuj@localhost
обсуждение исходный текст
Ответ на Query plan for very large number of joins  (<philb@vodafone.ie>)
Список pgsql-performance

> I am using PostgreSQL (7.4) with a schema that was generated
> automatically (using hibernate).
> The schema consists of about 650 relations. One particular query (also
> generated
> automatically) consists of left joining approximately 350 tables. At this

    Just out of curiosity, what application is this ?
    And what are the reasons for so many tables ...and especially such a
query ?
    Not criticizing, but curious.

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

Предыдущее
От: Vivek Khera
Дата:
Сообщение: Re: Adaptec/LSI/?? RAID
Следующее
От: mudfoot@rawbw.com
Дата:
Сообщение: Re: Adaptec/LSI/?? RAID (what about JBOD?)