Robert Haas <robertmh...@gmail.com> writes:
> On Sat, Oct 17, 2009 at 9:41 PM, Tom Lane <t...@sss.pgh.pa.us> 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?

Hmm, yeah maybe, now that we have some join removal logic.  Seems a bit
of a stretch to claim that's a common real-world case though.

                        regards, tom lane

-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

Reply via email to