Re: correlated exists with join is slow.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Glad to hear postgresql becomes better and better :)

2012/6/18 Tom Lane <tgl@xxxxxxxxxxxxx>
=?KOI8-U?B?96bUwcymyiD0yc3eydvJzg==?= <tivv00@xxxxxxxxx> 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

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux