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

From: Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: CTE with JOIN of two tables is much faster than a regular query
Date: 2018-08-18 10:26:30
Message-ID: 42ce9b74-0671-ecba-3deb-dc8bc8d5e9b3@a-kretschmer.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Am 18.08.2018 um 11:36 schrieb kpi6288(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message kpi6288 2018-08-18 11:08:28 AW: CTE with JOIN of two tables is much faster than a regular query
Previous Message kpi6288 2018-08-18 09:36:53 CTE with JOIN of two tables is much faster than a regular query