Re: Calculation of unused columns

Поиск
Список
Период
Сортировка
Искать
От
Robert Haas
Тема
Re: Calculation of unused columns
Дата
Msg-id
603c8f070910171853l5f2a81ai71f00417f8a2e959@mail.gmail.com
Ответ на
Список
Дерево обсуждения
Re: Calculation of unused columns Tim Landscheidt <tim@tim-landscheidt.de>
Re: Calculation of unused columns Jeff Janes <jeff.janes@gmail.com>
Re: Calculation of unused columns Robert Haas <robertmhaas@gmail.com>
Re: Calculation of unused columns Tom Lane <tgl@sss.pgh.pa.us>
Re: Calculation of unused columns Robert Haas <robertmhaas@gmail.com>
Re: Calculation of unused columns Tom Lane <tgl@sss.pgh.pa.us>
Re: Calculation of unused columns Tom Lane <tgl@sss.pgh.pa.us>
Re: Calculation of unused columns Gerhard Wiesinger <lists@wiesinger.com>
Re: Calculation of unused columns Tom Lane <tgl@sss.pgh.pa.us>
On Sat, Oct 17, 2009 at 9:41 PM, Tom Lane  wrote:
> I've been thinking about this since your earlier mail, and I think it
> would probably be possible to suppress unused columns in a non-flattened
> subquery.  I remain unconvinced that it's worth the trouble though.
> A real (not handwavy) example would help make the case here.

Are there any situations where this would enable join removal that
otherwise wouldn't be possible?  Maybe a query involving an
unflattenable VIEW?

...Robert
В списке pgsql-performance по дате отправления
От: Tom Lane
Дата:
От: 旭斌 裴
Дата:
FAQ