Re: [PERFORM] Slow query with 3 table joins

Поиск
Список
Период
Сортировка
От Johan Fredriksson
Тема Re: [PERFORM] Slow query with 3 table joins
Дата
Msg-id 1493206557.30225.5.camel@kth.se
обсуждение исходный текст
Ответ на Re: [PERFORM] Slow query with 3 table joins  (Alessandro Ferrucci <alessandroferrucci@gmail.com>)
Список pgsql-performance
> Hi Eskil -
>
>
> The I believe the id-field you're referring to is the UNIT.UNIT_ID, I
> could change this to a varchar, however that column is not used in the
> query in question, so that wouldn't have any effect on the query's
> performance.

Sorry, I did not notice that the column "unit_id" existed in both "unit"
and "field" tables.

        / Eskil





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

Предыдущее
От: Alessandro Ferrucci
Дата:
Сообщение: Re: [PERFORM] Slow query with 3 table joins
Следующее
От: Gerardo Herzig
Дата:
Сообщение: Re: [PERFORM] Slow query with 3 table joins