Re: Subquery in a JOIN not getting restricted?

Поиск
Список
Период
Сортировка
От Jay Levitt
Тема Re: Subquery in a JOIN not getting restricted?
Дата
Msg-id 4EBBF0FD.5050506@gmail.com
обсуждение исходный текст
Ответ на Re: Subquery in a JOIN not getting restricted?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
> Don't hold your breath waiting for that to change.  To do what you're
> wishing for, we'd have to treat the GROUP BY subquery as if it were an
> inner indexscan, and push a join condition into it.  That's not even
> possible today.

Thanks! Knowing "that's not a thing" helps; we'll just have to rephrase the
query.

Jay

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Subquery in a JOIN not getting restricted?
Следующее
От: kzsolt
Дата:
Сообщение: Re: Heavy contgnous load