Re: Calculation of unused columns
От
Robert Haas
Тема
Re: Calculation of unused columns
Дата
Msg-id
603c8f070910171853l5f2a81ai71f00417f8a2e959@mail.gmail.com
Ответ на
Re: Calculation of unused columns (Tom Lane)
Список
Дерево обсуждения
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 по дате отправления