Re: optimizing away join when querying view - Mailing list pgsql-performance

From Tom Lane
Subject Re: optimizing away join when querying view
Date
Msg-id 7893.1139413057@sss.pgh.pa.us
Whole thread Raw
In response to optimizing away join when querying view  (Jacob Costello <jake@suntradingllc.com>)
List pgsql-performance
Jacob Costello <jake@suntradingllc.com> writes:
> Postgres doesn't seem to optimize away unnecessary joins

There is no such thing as an unnecessary join, unless you are willing to
stake the correctness of the query on constraints that could be dropped
after the query is planned.  Until we have some infrastructure to deal
with that situation, nothing like this is going to happen.

            regards, tom lane

pgsql-performance by date:

Previous
From: Ron
Date:
Subject: Size and performance hit from using UTF8 vs. ASCII?
Next
From: Stephan Szabo
Date:
Subject: Re: optimizing away join when querying view