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

From Kevin Grittner
Subject Re: correlated exists with join is slow.
Date
Msg-id 4FDEFBC002000025000485EB@gw.wicourts.gov
Whole thread Raw
In response to Re: correlated exists with join is slow.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Tom Lane <tgl@sss.pgh.pa.us> wrote:

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

Yeah, with HEAD on my workstation all of these queries run in less
than 0.1 ms.  On older versions, I'm seeing times like 100 ms to 150
ms for the slow cases.  So in this case, parameterized paths allow
an improvement of more than three orders of magnitude.  :-)

-Kevin

pgsql-performance by date:

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