Re: postgres 9 query performance - Mailing list pgsql-performance

From Tom Lane
Subject Re: postgres 9 query performance
Date
Msg-id 21572.1296425895@sss.pgh.pa.us
Whole thread Raw
In response to Re: postgres 9 query performance  (Andres Freund <andres@anarazel.de>)
Responses Re: postgres 9 query performance  (Andres Freund <andres@anarazel.de>)
Re: postgres 9 query performance  ("Ross J. Reedstrom" <reedstrm@rice.edu>)
List pgsql-performance
Andres Freund <andres@anarazel.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

pgsql-performance by date:

Previous
From: "Mark Felder"
Date:
Subject: Re: Any experience using "shake" defragmenter?
Next
From: Marcin Mirosław
Date:
Subject: Re: Any experience using "shake" defragmenter?