Re: correlated exists with join is slow.

Поиск
Список
Период
Сортировка
От Віталій Тимчишин
Тема Re: correlated exists with join is slow.
Дата
Msg-id CABWW-d2SHStw5dv-JNfc-t-uQe=6KOzc5-_jR3_nkbvUZKn6Nw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: correlated exists with join is slow.  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: correlated exists with join is slow.
Следующее
От: Anish Kejariwal
Дата:
Сообщение: Re: Expected performance of querying 5k records from 4 million records?