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

From Віталій Тимчишин
Subject Re: correlated exists with join is slow.
Date
Msg-id CABWW-d2SHStw5dv-JNfc-t-uQe=6KOzc5-_jR3_nkbvUZKn6Nw@mail.gmail.com
Whole thread Raw
In response to Re: correlated exists with join is slow.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Glad to hear postgresql becomes better and better :)

2012/6/18 Tom Lane <tgl@sss.pgh.pa.us>
Віталій Тимчишин <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

-- 
Best regards,
 Vitalii Tymchyshyn

pgsql-performance by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: correlated exists with join is slow.
Next
From: Anish Kejariwal
Date:
Subject: Re: Expected performance of querying 5k records from 4 million records?