Віталій Тимчишин <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.