Andres Freund <andres(at)anarazel(dot)de> 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.  Fixed now:
http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=1df57f63f3f60c684aa8918910ac410e9c780713

			regards, tom lane

In response to

• Re: postgres 9 query performance at 2011-01-28 21:19:29 from Andres Freund

Responses

• Re: postgres 9 query performance at 2011-01-30 22:35:03 from Andres Freund
• Re: postgres 9 query performance at 2011-02-01 16:42:53 from Ross J. Reedstrom

pgsql-performance by date

Next:	From: Marcin Mirosław	Date: 2011-01-30 22:27:16
	Subject: Re: Any experience using "shake" defragmenter?
Previous:	From: Mark Felder	Date: 2011-01-30 21:31:26
	Subject: Re: Any experience using "shake" defragmenter?