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

[Andreas Kretschmer]

Am 18.08.2018 um 11:36 schrieb kpi6...@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