Postgres Pro
Downloads
Home   >   mailing lists

Re: Why PG uses nested-loop join when no indexes are available? - Mailing list pgsql-general

From Tom Lane
Subject Re: Why PG uses nested-loop join when no indexes are available?
Date
Msg-id 29747.1452697358@sss.pgh.pa.us
Whole thread Raw
In response to Why PG uses nested-loop join when no indexes are available?  (David Grelaud <dgrelaud@ideolys.com>)
Responses Re: Why PG uses nested-loop join when no indexes are available?
List pgsql-general
Tree view 
David Grelaud <dgrelaud@ideolys.com> writes:
> Statistics are not propagated when Common Table Expressions (CTE) are used.
> The cardinality of a CTE is equal to 1 most of the time

Really?

The rest of this seems to be proceeding from completely false assumptions.

            regards, tom lane

pgsql-general by date:

Previous
From: David Grelaud
Date:
Subject: Why PG uses nested-loop join when no indexes are available?
Next
From: Kevin Grittner
Date:
Subject: Re: WIP: CoC V5