Aggregate and many LEFT JOIN

Поиск
Список
Период
Сортировка
От kimaidou
Тема Aggregate and many LEFT JOIN
Дата
Msg-id CAMKXKO6Ltz14uVgAyxy-cGSZoOQCbU5__2mjgVPv90snONZjNw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Aggregate and many LEFT JOIN
Список pgsql-performance
Дерево обсуждения
Hi all,

I need to optimize the following query
I use it to create  a materialized view, but I think there is room for optimization.
I tried to
SET join_collapse_limit TO 15;
with to real difference.

Explain shows that the GROUP AGGREGATE and needed sort kill the performance.
Do you have any hint how to optimize this ?

Regards
Michaël

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

Предыдущее
От: Gunther Schadow
Дата:
Сообщение: Re: neither CPU nor IO bound, but throttled performance
Следующее
От: kimaidou
Дата:
Сообщение: Slow query with aggregate and many LEFT JOINS