Re: correlated exists with join is slow. - Mailing list pgsql-performance

From Tom Lane
Subject Re: correlated exists with join is slow.
Date
Msg-id 9674.1340031155@sss.pgh.pa.us
Whole thread Raw
In response to correlated exists with join is slow.  (Віталій Тимчишин <tivv00@gmail.com>)
Responses Re: correlated exists with join is slow.  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Re: correlated exists with join is slow.  (Віталій Тимчишин <tivv00@gmail.com>)
List pgsql-performance
=?KOI8-U?B?96bUwcymyiD0yc3eydvJzg==?= <tivv00@gmail.com> writes:
> Today I've found a query that I thought will be fast turned out to be slow.
> The problem is correlated exists with join - it does not want to make
> correlated nested loop to make exists check.

9.2 will make this all better.  These are exactly the type of case where
you need the "parameterized path" stuff.

            regards, tom lane

pgsql-performance by date:

Previous
From: Віталій Тимчишин
Date:
Subject: correlated exists with join is slow.
Next
From: "Kevin Grittner"
Date:
Subject: Re: correlated exists with join is slow.