Re: Turn correlated in subquery into join

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Turn correlated in subquery into join
Дата
Msg-id 4995.1206376211@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Turn correlated in subquery into join  (Dennis Bjorklund <db@zigo.dhs.org>)
Список pgsql-performance
Dennis Bjorklund <db@zigo.dhs.org> writes:
> Look like the mysql people found a subquery that postgresql doesn't
> handle as good as possible:

>    http://s.petrunia.net/blog/

> Is there some deeper issue here that I fail to see or is it simply that
> it hasn't been implemented but is fairly straigt forward?

I don't think it's straightforward: you'd need to do some careful
analysis to prove under what conditions such a transformation would be
safe.  If the answer is "always, it doesn't matter what the correlation
condition is" then the actual implementation would probably not be
tremendously difficult.  If there are restrictions then checking whether
the restrictions hold could be interesting ...

            regards, tom lane

В списке pgsql-performance по дате отправления:

Предыдущее
От: PFC
Дата:
Сообщение: Re: waiting for harddisk
Следующее
От: "Steve Poe"
Дата:
Сообщение: Planning hot/live backups?