Re: Slow query when the select list is big

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Slow query when the select list is big
Дата
Msg-id CAKFQuwYOCLqojT9Grv=prbN7_N0eQcgmtOrZs9X6DFa0BCDA=A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Slow query when the select list is big  ("Sterpu Victor" <victor@caido.ro>)
Ответы Re: Slow query when the select list is big  (David Rowley <david.rowley@2ndquadrant.com>)
Список pgsql-general
On Sunday, May 8, 2016, Sterpu Victor <victor@caido.ro> wrote:
Yes but it is very big.
I don't understand why the select list is influencing the CPU usage.
I was expecting that only the join and where clauses would influence CPU.


PostgreSQL is smart enough to optimize away stuff that it knows doesn't impact the final query result.

David J.
 

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

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: Slow query when the select list is big
Следующее
От: David Rowley
Дата:
Сообщение: Re: Slow query when the select list is big