Robert Haas <robertmhaas@xxxxxxxxx> writes: > On Sat, Oct 17, 2009 at 9:41 PM, Tom Lane <tgl@xxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
