Postgres Pro
Downloads
Home   >   mailing lists

Re: CTE vs Subquery - Mailing list pgsql-performance

From Tom Lane
Subject Re: CTE vs Subquery
Date
Msg-id 24672.1319561025@sss.pgh.pa.us
Whole thread Raw
In response to CTE vs Subquery  (Linos <info@linos.es>)
Responses Re: CTE vs Subquery  (Linos <info@linos.es>)
List pgsql-performance
Tree view 
Linos <info@linos.es> writes:
>     i am having any problems with performance of queries that uses CTE, can the
> join on a CTE use the index of the original table?

CTEs act as optimization fences.  This is a feature, not a bug.  Use
them when you want to isolate the evaluation of a subquery.

            regards, tom lane

pgsql-performance by date:

Previous
From: Linos
Date:
Subject: CTE vs Subquery
Next
From: Linos
Date:
Subject: Re: CTE vs Subquery