Glad to hear postgresql becomes better and better :)
2012/6/18 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
> =?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
> > 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
pgsql-performance by date
|Next:||From: Anish Kejariwal||Date: 2012-06-18 16:39:31|
|Subject: Re: Expected performance of querying 5k records from 4
|Previous:||From: Kevin Grittner||Date: 2012-06-18 14:58:24|
|Subject: Re: correlated exists with join is slow.|