Re: LEFT JOINs not optimized away when not needed

Поиск
Список
Период
Сортировка
От Moshe Jacobson
Тема Re: LEFT JOINs not optimized away when not needed
Дата
Msg-id CAJ4CxLkYMm6wV-5yhGtRVXOHsP-9CkXafhsT=+2D6-9dkMueiA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: LEFT JOINs not optimized away when not needed  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: LEFT JOINs not optimized away when not needed  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
On Tue, Jul 8, 2014 at 4:40 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:

> No.  There is nothing about GROUP BY in the join removal logic.
>

OK. Thank you. Is this something that would make sense to add?

More importantly, do you have any suggestions on how we can improve the
speed of our views when only a couple of columns are selected from them?


Moshe Jacobson
Manager of Systems Engineering, Nead Werx Inc. <http://www.neadwerx.com>
2323 Cumberland Parkway =C2=B7 Suite 201 =C2=B7 Atlanta, GA 30339

"Quality is not an act, it is a habit." -- Aristotle

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: LEFT JOINs not optimized away when not needed
Следующее
От: "Burgess, Freddie"
Дата:
Сообщение: Re: Postgresql 9.3.4 Streaming Replication Standby invalid Page block