Re: correlated exists with join is slow.

[Віталій Тимчишин <tivv00@xxxxxxxxx>]

Glad to hear postgresql becomes better and better :)

2012/6/18 Tom Lane <tgl@xxxxxxxxxxxxx>

=?KOI8-U?B?96bUwcymyiD0yc3eydvJzg==?= <tivv00@xxxxxxxxx> 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

-- 
Best regards,
 Vitalii Tymchyshyn