On Sunday 30 January 2011 23:18:15 Tom Lane wrote: > Andres Freund <andres@xxxxxxxxxxx> writes: > > What happens if you change the > > > > left join event.origin on event.id = origin.eventid > > > > into > > > > join event.origin on event.id = origin.eventid > > > > ? > > > > The EXISTS() requires that origin is not null anyway. (Not sure why the > > planner doesn't recognize that though). > > Sloppy thinking in reduce_outer_joins() is why. Wow. Nice one, thanks. Andres -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
