Re: CTE with JOIN of two tables is much faster than a regular query

Поиск
Список
Период
Сортировка
От Andreas Kretschmer
Тема Re: CTE with JOIN of two tables is much faster than a regular query
Дата
Msg-id 42ce9b74-0671-ecba-3deb-dc8bc8d5e9b3@a-kretschmer.de
обсуждение исходный текст
Ответ на CTE with JOIN of two tables is much faster than a regular query  (<kpi6288@gmail.com>)
Ответы AW: CTE with JOIN of two tables is much faster than a regular query  (<kpi6288@gmail.com>)
Список pgsql-general
Дерево обсуждения 

Am 18.08.2018 um 11:36 schrieb kpi6288@gmail.com:
> What can I do to improve the performance of the regular query without 
> using a CTE? 

try to rewrite it to a subselect:

select ... from ... join (selec ... from ... where ...) x on ...


Regards, Andreas

-- 
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com

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

Предыдущее
От:
Дата:
Сообщение: CTE with JOIN of two tables is much faster than a regular query
Следующее
От:
Дата:
Сообщение: AW: CTE with JOIN of two tables is much faster than a regular query