Re: correlated exists with join is slow.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Віталій Тимчишин <tivv00(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: correlated exists with join is slow.
Date: 2012-06-18 14:52:35
Message-ID: 9674.1340031155@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

=?KOI8-U?B?96bUwcymyiD0yc3eydvJzg==?= <tivv00(at)gmail(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Kevin Grittner 2012-06-18 14:58:24 Re: correlated exists with join is slow.
Previous Message Віталій Тимчишин 2012-06-18 13:47:42 correlated exists with join is slow.