Postgres Pro
Downloads
Home   >   mailing lists

Re: CTE with JOIN of two tables is much faster than a regular query - Mailing list pgsql-general

From Andreas Kretschmer
Subject Re: CTE with JOIN of two tables is much faster than a regular query
Date
Msg-id 42ce9b74-0671-ecba-3deb-dc8bc8d5e9b3@a-kretschmer.de
Whole thread Raw
In response to CTE with JOIN of two tables is much faster than a regular query  (<kpi6288@gmail.com>)
Responses AW: CTE with JOIN of two tables is much faster than a regular query
List pgsql-general
Tree view 

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 by date:

Previous
From:
Date:
Subject: CTE with JOIN of two tables is much faster than a regular query
Next
From:
Date:
Subject: AW: CTE with JOIN of two tables is much faster than a regular query