Re: [GENERAL] a JOIN to a VIEW seems slow

Поиск
Список
Период
Сортировка
От Frank Millman
Тема Re: [GENERAL] a JOIN to a VIEW seems slow
Дата
Msg-id A660D5C7AB774CB0983C9252C1B49585@FrankLaptop
обсуждение исходный текст
Ответ на Re: [GENERAL] a JOIN to a VIEW seems slow  (David Rowley <david.rowley@2ndquadrant.com>)
Список pgsql-general
Дерево обсуждения
 
On 7 October 2017 at 2:49 PM, David Rowley wrote:
>
>
Yeah, PostgreSQL does not make any effort to convert subqueries in the
>
target list into joins. SQL server does.
[...]
>
You'll probably find it'll run faster if you convert the subquery in
>
the target list into a join with a GROUP BY, like ...
>
 
Wow, David, that is perfect – 0.91 seconds. Problem well and truly solved.
 
It took me a little while to modify my original query to use that concept, but now it flies.
 
Many thanks
 
Frank
 

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

Предыдущее
От: Hung Phan
Дата:
Сообщение: [GENERAL] table partition problem
Следующее
От: Andreas Joseph Krogh
Дата:
Сообщение: [GENERAL] OR-clause support for indexes